#1
|
|||
|
|||
COUNTIF Formula
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 |
#2
|
||||
|
||||
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
__________________
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 |
#3
|
|||
|
|||
Try COUNTIFS()
|
#4
|
||||
|
||||
@ Jaffary COUNTIFS does not allow 3D references either although SUMPRODUCT does
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
Countif issue | Katy I | Excel | 2 | 07-11-2012 06:30 AM |
IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
Vlookup, offset, match & countif | jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |