How do I define column C so C(n) =A(n)+B(n)

S

S M Raucher

I want to create a spreadsheet where some cell entries are mathematical
functions of data in corresponding cells (same row) of other columns. For
example, assume fixed data in columns A and B. In column C, I want C(1) to =
A(1) + B(1) etc.
 
J

JulieD

Hi

in C1 type
=A1+B1
then move your cursor over the bottom right hand corner until you see a +
(known as the autofill handle)
hold the left mouse down and drag down the column as far as you need to go
and let go, the formula will be filled in for you for each line

Cheers
julieD
 
Top