Adding values from several sheets

[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

 

[Myrna Larson]

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

=SUM(Sheet1:Sheet5!S13)

 

[John P]

Thanks Myrna

That got me back on track.

Cheers

John

 

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

 

[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".