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
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
If you have some time, can you explain the formula to me? I understand some of it :-) thanks
Phil
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.
