Problems with countif function

[NavyGunner]

What I am trying to do is tally up the total times I see a certain txt in a
certain row for 31 wrok sheets.

Example:
=countif('1st:31st'!G2) now I know this is totally wrong, but it shows kinda
what I want. I want all of the G2 cells for the 31 work sheets to tally up
the text, will say W1R in a designated cell on my summary page work sheet.
That way anytime I put W1R in any of that row for any sheet it will add it to
the summary total. Also if it says M1R it will be tallied in a cell with that
title on the summary work sheet, and so on... My main goal is to use this
function to track how many times that particular text was ever done. I will
appreciate your help.

 

[T. Valko]

=countif('1st:31st'!G2)

Are those your real sheet names, 1st through 31st? What about the sheet
names for the 2nd or 3rd or 15th?

This can be done but all the sheet names have to follow a common pattern.
Getting rid of the ordinal would work. For example, sheet names of just
1,2,3,4....31.

 

[NavyGunner]

I changed the work sheet names to 1,2,3,4... now what is the next step?

 

[T. Valko]

I changed the work sheet names to 1,2,3,4

This formula will count how many times W1R appears in cell G2 on all 31
sheets:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:31"))&"'!G2"),"W1R"))

Note that you *must* have all 31 sheets