Advanced COUNTIF Function

L

License Boy

Is there a way to use the COUNTIF Function across worksheets and place the
total on a seperate worksheet?
 
F

Frank Kabel

Hi
could you give some more details:
- how are your sheets named
- which columns to count
 
B

Bernard Liengme

If you lookup Help for "3d reference" and open the topic "Refer to the same
cell or range on multiple sheets" you get a list of functions that can be
used with 3D references. Unfortunately, COUNTIF and SUMPRODUCT are not
listed

best wishes
 
J

Jason Morin

The best way to learn is through example:

=SUM(COUNTIF(INDIRECT({"Invoices","Backlog","Deliveries"}
&"!A:A"),4))

Translated: COUNT column A if it equals 4 for the 3 named
worksheets, and sum those 3 counts.

One drawback is that if a sheet name is changed, the
formula will error out.

HTH
Jason
Atlanta, GA
 
Top