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:3 1"))&"'!G2"),"W1R"))

Note that you *must* have all 31 sheets

--
Biff
Microsoft Excel MVP


"NavyGunner" wrote in message
...
I changed the work sheet names to 1,2,3,4... now what is the next step?

"T. Valko" wrote:

=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.

--
Biff
Microsoft Excel MVP


"NavyGunner" wrote in message
...
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.