sum function with rows

  • Thread starter Thread starter Alyson
  • Start date Start date
A

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 **
 
Hi
if you enter
=SUM(A1,B1,C19

or even better
=SUM(A1:C1)
in row one simply copy this formula down
 
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
 
=sum($a$1:a2)

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






you wrote:
 
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.
 
Back
Top