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?
.