Mar 31 2019 08:06 AM
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
Mar 31 2019 08:15 AM
Mar 31 2019 08:21 AM
Mar 31 2019 08:34 AM
@Twifoo That's your only advice?
Mar 31 2019 10:40 AM
Mar 31 2019 02:22 PM - edited Mar 31 2019 02:25 PM
SolutionThanks 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
Mar 31 2019 02:57 PM
Mar 31 2019 09:38 PM
If you have some time, can you explain the formula to me? I understand some of it :) thanks
Phil
Apr 01 2019 12:54 PM
Use formula evaluation.
The matches result in a two-dimensional matrix with TRUE and FALSE.
-- converts them to 1 and 0.
MMULT() transform them into a one-dimensional column.
SUMPRODUCT() multiplies both matrices and adds them up.
Mar 31 2019 02:22 PM - edited Mar 31 2019 02:25 PM
SolutionThanks 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