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.