Forum Discussion

GrasshoppersPhil's avatar
GrasshoppersPhil
Copper Contributor
Mar 31, 2019
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 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

  • Detlef_Lewin 

    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).  
    Thanks

    Phil

8 Replies

Resources