SUM Question

[Guest]

I have a Workbook containing multiple Worksheets. Each Worksheet has the same
number of Columns but different number of rows. The last row of each
Worksheet contains the Sum for each Column. Is there a formula that will SUM
all of a given Column's totals for all Worksheets, even though the number of
rows is different in each Worksheet?

 

[Bob Phillips]

It would be much easier if you put your total in row 1 and then sum across
row 1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[RagDyeR]

How about placing the SUM() function at the *top* of the column, just under
the header, and then you'll have the same cell on each sheet to use for
totaling.

=SUM(Sheet1:Sheet15!A3)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have a Workbook containing multiple Worksheets. Each Worksheet has the
same
number of Columns but different number of rows. The last row of each
Worksheet contains the Sum for each Column. Is there a formula that will SUM
all of a given Column's totals for all Worksheets, even though the number of
rows is different in each Worksheet?

 

[Dallman Ross]

How about placing the SUM() function at the *top* of the column,
just under the header, and then you'll have the same cell on each
sheet to use for totaling.

=SUM(Sheet1:Sheet15!A3)

In case the OP still doesn't want to move the SUM(), though,
this would work as one way, assuming there are no blanks in the
column data:

=SUM(OFFSET(Sheet1!B1,COUNTA(Sheet1!B:B)-1,),OFFSET(Sheet2!B1,COUNTA(Sheet2!B:B)-1,))

(Assumes the column we're interested in here is B and there are two sheets.)

-dman-
============================================