ExcelBanter - Subtotal across multiple sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtotal across multiple sheets (https://www.excelbanter.com/excel-discussion-misc-queries/25732-subtotal-across-multiple-sheets.html)

Saira

Subtotal across multiple sheets

Hi there
Does anyne know if you can use the subtotal function across multiple sheets?
If so how?
I have tried to use the following, but all I get is a #VALUE.
I assume this is because of the colon.

=Subtotal(1,Sheet1:Sheet2!A1)

Any help would be much appreciated.

Thanks
Saira

subtotal will not do 3D calcs.

"Saira" wrote:

Hi there
Does anyne know if you can use the subtotal function across multiple sheets?
If so how?
I have tried to use the following, but all I get is a #VALUE.
I assume this is because of the colon.

=Subtotal(1,Sheet1:Sheet2!A1)

Any help would be much appreciated.

Thanks
Saira

Jim May

Try:
=SUBTOTAL(1,Sheet1!B4:B5,Sheet2!B4:B5)

"Saira" wrote in message
...
Hi there
Does anyne know if you can use the subtotal function across multiple
sheets?
If so how?
I have tried to use the following, but all I get is a #VALUE.
I assume this is because of the colon.

=Subtotal(1,Sheet1:Sheet2!A1)

Any help would be much appreciated.

Thanks
Saira

All times are GMT +1. The time now is 08:40 PM.