Forum Discussion
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 row by row if an official is to see the team. (and it can't be a full range on the page, or it tells me how many times in the cells I have the referee and then the team, not taking into account that they maybe on different games.
I tried the countifs function and can't seem to get it to work....I'm pretty good with excel so pulling out my hair here :-)
Thanks
Phil
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
8 Replies
- Detlef_LewinSilver Contributor
- GrasshoppersPhilCopper Contributor
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
- GrasshoppersPhilCopper Contributor
If you have some time, can you explain the formula to me? I understand some of it :-) thanks
Phil
- GrasshoppersPhilCopper Contributor
- TwifooSilver ContributorI suggest that you first convert the layout of your data to flat file format to facilitate calculations thereon. Unmerge all cells.
- GrasshoppersPhilCopper Contributor
Twifoo That's your only advice?