=SUM(COUNTIF(INDIRECT("Sheet"&{1,2,3,4}&"!Z$4:Z$40 00"),"b"))

"Jock" wrote:

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