sum function with rows

[Alyson]

I want to add specific cells within each row of my spreadsheet.
Obviously I can type =SUM(A1, B1, C1) and =SUM(A2, B2, C2) each time,
but that will be very time-consuming. Is there some generic symbol that
will represent the current row number in the formula? Or some other way
I could fill-down a formula that adjusts for each row? Please help.
Thanks.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
if you enter
=SUM(A1,B1,C19

or even better
=SUM(A1:C1)
in row one simply copy this formula down

 

[Don Guillett]

try
=sum($a$1:a2) and copy down

 

[Alyson]

Hi, thank you for your response. When I copy it down, it doesn't change
the row number.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[W. D. Allen Sr.]

Check out Chip Pearson's website for your answer!

end

 

[Frank Kabel]

Hi
try the following:
- insert the formula in cell B1 for example
- now click on the lower right corner of this cell with your mouse and
drag the selection down. The formula should change

 

[jim_millions]

=sum($a$1:a2)

where do you get $a, $1, and I assume "a2" is row a and col 2?






you wrote: