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

[Guest]

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.

 

[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

 

[Chip Pearson]

Just use a formula like the following in cell C1.

=A1+B1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...