Error summing same cell multiple worksheets!

  • Thread starter Thread starter kydan47
  • Start date Start date
K

kydan47

Could anyone tell me what could be causing my problem?

I have a workbook containing a master worksheet followed
by several additional worksheets. I wanted to obtain a
master total for the same cell in each of the subsequent
worksheets.

I have tried both methods (plus and sum) with error
messages for each. With the sum formula, I get a #REF!
error.

Any suggestions?

Thanks in advance,
kentucky dan
 
Hi
normally you could just enter something like
=SUM('sheet2:sheet20'!B1)

you may post your formula which causes the error
 
Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

All worksheets between these sheets will be sum
with this formula

=SUM(start:end!B2)
 
Dan,

Try a 3-D reference.

Example:

This would give the sum of Sheet 2 through Sheet 13 for
the location B5 on all the sheets.

=Sum(Sheet2:Sheet13!B5)

Larry
 
Back
Top