Adding values from several sheets

J

John P

I would like to add the values from five sheets in the same workbook from
cells containing =COUNTIF(B12:S12,9) (or similar.

Unfortunately the normal method of copying and pasting returns an error
(#ref) as though it is looking for the range on the summary sheet?

Can anyone help please?

Thanks

John P
 
M

Myrna Larson

Are the values on the 5 sheets in the same location, say S13?

=SUM(Sheet1:Sheet5!S13)
 
M

Murtaza

That is simply WONDER, i could not even thought of it.

How come people get such advanced solution, i mean i have checked the
Microsoft Excel Help but could not find this use of SUM function.

Thanks this also helps me a lot.
 
M

Myrna Larson

It's called a 3-D reference (3-dimensional). Search for 3-D referenced in
Help. The information is under "Cell and Range References".
 
Top