look in the same range in sheet1!, sheet2!
and sheet3! as well as sheet 4!

If you only have a "few" sheets...

=COUNTIF(Sheet1!Z$4:Z$4000,"b")+COUNTIF(Sheet2!Z$4 :Z$4000,"b")+COUNTIF(Sheet3!Z$4:Z$4000,"b")+COUNTI F(Sheet4!Z$4:Z$4000,"b")

--
Biff
Microsoft Excel MVP


"Jock" wrote in message
...
How can I adapt the following to also look in the same range in sheet1!,
sheet2! and sheet3! as well as sheet 4! ?
=COUNTIF(sheet4!Z$4:Z$4000,"b")
--
Traa Dy Liooar

Jock