sum total
 

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

sum total
 

"marlenar" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

sum total
 

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" wrote:

"marlenar" wrote:
In a sum total column, how do 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

sum total
 

"marlenar" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

sum total
 

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

"Max" wrote:

"marlenar" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

sum total
 

Welcome, thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"marlenar" wrote in message
...
Thank you so much, Max. That was just the answer I needed. Solved my
problem.