I have a spreadsheet with about 26 tabs.

On the last tab i am totalling up the data from the other tabs. With the COUNTIF formula, how can i select all the sheets for the range, as it wont let me select them all individually as there are too many tabs

thanks

I'm afraid COUNTIF does not allow 3 D referencing.

You'll find some workarounds at this site (replace SUM with COUNT) and other places too on the web

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Try COUNTIFS()

@ Jaffary COUNTIFS does not allow 3D references either although SUMPRODUCT does

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post