I have data in one sheet in my workbook with that sheet name being "20130509".
in another sheet I have formulas:
In Cell A2 is the text "20130509" without the quotes.
In Cell B1 is the text "NCAA" without the quotes
In cell C1 is the text "NFL" without the quotes
In Cell B2 is the formula =countifs('20130509'!$H$3:$H$10000,$B1)
In Cell C2 is the formula =countifs('20130509'!$H$3:$H$10000,$C1)
Is there a way to change the formula in cells B2 and C2 so that it references the text in A2 such that if I change the text in A2 to a different sheet, say "20130517" the formulas all work for the new sheet?
Thanks,
Tim
Bookmarks