Advanced COUNTIF Function

[Guest]

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

 

[Guest]

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

 

[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

 

[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