Forum Discussion
Solved
Counting multiple cells problem (countif)
Hello all, Having trouble getting a formula to count an entire cell range for me. I'm assigning hockey games and trying to figure out how many times one referee will see a team. How do I count ...
Thanks for the response... this is awesome...how did you get this formula (if you don't mind me asking as I use excel often and am now very curious).
ThanksPhil
I suggest that you first convert the layout of your data to flat file format to facilitate calculations thereon. Unmerge all cells.
Twifoo That's your only advice?