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