It does, but not 3d.

Try this. Put the names of all the target sheets in M1:Mn and use

=SUMPRODUCT(COUNTIF(INDIRECT("'"&M1:Mn&"'!I1"),"GP 38"))

obviously adjust to n to suit.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"skijsh1979" wrote in message
...
=COUNTIF('BNSF 2176:BNSF 8037'!I1,"GP38")

I am attempting to count the number of times the text string "GP38" is
present in cell "I1" of a select group of worksheets within the same work
book. The error I get is "#value" When I run error checking on the
funtion,
it says that a value in the formula is of the wrong data type. I was
under
the impression that "COUNTIF" could be used for text also.

Thanks,

Justin