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