| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum total
In a sum total column, how do I add more than one row at a time?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
