Here's an example:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Sheet1","Sheet2 ","Sheet3"}&"'!A1"),"apple"))

Here I want a total count of the word "apple" appearing in A1 of Sheet1,
Sheet2, and Sheet3.

HTH
Jason
Atlanta, GA


"Xanadude" wrote:

Can the 3-D formula be used for finding text?
I'm trying to incorporate it into the =countif function, but I just get
errors.

Or is there another way to count the # of cells (1 per page) that have a
specific text in them? The cells are in the same position on all pages to be
looked at.