It is hard to use a 3D reference with SUMPRODUCT
See T. Valko's (aka Biff) message at
http://groups.google.com/group/micro...14e43c6?hl=en#

Why not enter a SUMPRODUCT on each sheet an SUM these on the summary sheet
Since the sheets all have the same structure, the simple way to have a
SUMPRODUCT formula on all sheets would be to group these sheets, type the
formula and ungroup.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Sonny" wrote in message
...
I have a SUMPRODUCT function that works nice on a spreadsheet. Now I want
to
add several more sheets in the SUMPRODUCT function, without adding a hole
new
SUMPRODUCT function for each sheet. The structure is the same in each
sheet.

How do I reference several sheets in the same SUMPRODUCT function?

Thanks in advance!