I am trying to do a count of how many cells equal specific text. I tried to do a COUNTA already, but the cells I'm trying to add have a formula in them so its counting all of them. Also tried to do a COUNTIF, but it was becoming an extremely long formula. I also tried to do a range across multiple worksheets, but couldn't make that work either.
I have attached a sample book, deleted data that is not relevant. In the "SEASON" tab, I want column Y and AR to count if "O" or "D" is found in the cells in each of the other tabs. (There are 21 tabs to count from, I've included three in the sample.)
In each of the tabs not named "SEASON", cells Y6:Y55 and cells AO6:AO55 have a formula which calculates a possible value of "O" or "D" (can also have no value). If those cells have a value of "O" or "D", I want them to be counted in the "SEASON" tab in cells Y6:Y55 and AR6:AR55.
If the formula that is counting is correct the count should be five for all ten numbers that have an "O" or "D" value.
(Sample book removed after solved.)
Bookmarks