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
---