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?