sum total

  • Thread starter Thread starter marlenar
  • Start date Start date
marlenar said:
In a sum total column, how do I add more than one row at a time?
Click to expand...

Do you mean something like this, eg
In B2: =SUM(A2:A5)
which gives the total for A2:A5

or you could have in B2: =SUM(A:A)
which gives the total for col A

---
 
hi,

what i mean is this. e.g.: i have a worksheet with colums "a" , "b" , and
"c". i also have a "d" column which is the total column for the worksheet.
there are 10 rows. how do i total each row across at the same time to get
the total of each row in the total row. do i have to total each row
individually or can i highlight the whole sheet somehow to get each rows
total in the total column? i hope this makes sense and thank you for your
help.
 
marlenar said:
what i mean is this. e.g.: i have a worksheet with colums "a" , "b" , and
"c". i also have a "d" column which is the total column for the worksheet.
there are 10 rows. how do i total each row across at the same time to get
the total of each row in the total row. do i have to total each row
individually or can i highlight the whole sheet somehow to get each rows
total in the total column?
Click to expand...

Assuming data starts in row2 down
You could place in D2: =SUM(A2:C2),
press ENTER to confirm the formula,
then copy D2 down to D10 by dragging down the fill handle** of D2,
**the solid black square at the bottom right of D2

---
 
Back
Top