sum total

[marlenar]

In a sum total column, how do I add more than one row at a time?

 

[Max]

In a sum total column, how do I add more than one row at a time?

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

---

 

[marlenar]

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.

 

[Max]

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?

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

---

 

[marlenar]

Thank you so much, Max. That was just the answer I needed. Solved my problem.

 

[Max]

Welcome, thanks for feeding back.