One way

=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!B335: B343"),B22))


where MySheets is a named range with a list of all worksheet names
(insertnamedefine) or you can use the range reference itself like H1:H26
(if you use the 26 sheet names), note that each sheet name that you want
included has to be there

--
Regards,

Peo Sjoblom

(No private emails please)


"OZDOC1050" wrote in message
...
=COUNTIF(A:Z!B335:B343,B22)

When using this to count between several sheets I return an error, but
cant work out where I am going wrong. any help would be great

Pete

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)