Advanced COUNTIF Function
 

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

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


"License Boy" wrote:

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

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

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"License Boy" <License wrote in message
...
Is there a way to use the COUNTIF Function across worksheets and place the
total on a seperate worksheet?

The best way to learn is through example:

=SUM(COUNTIF(INDIRECT({"Invoices","Backlog","Deliv eries"}
&"!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

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