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:

 

[luis morales]

Lets take it from the top in analyzing the formula: In any formula you need
first the = sign to tell excel that it is a formula. Now you have to tell
excel what you want to do. In this case you want excel to add thus sum comes
into the picture. then you tell excel where to get the information from. if
you are doing a simple adddition, A1+A2 would be enough. The use of : is
when you are using more that two consecutive rows or columns. for example
A1:A11. this would make reference to all the cells listed inclusive. The $
makes this an absolute reference which means it will always include the
referenced cell in this case A1. If you copy the formula somewhere else it
will always add A1 and whatever the second part is. refer to help in excel
by going to absolute reference it will make it clear. I know this response
is long and drawn out but I hope it helps you and answers your question.