Excel Forum



Excel Magic Trick 491: Count Matches in Individual Cells


See how to use SUMPRODUCT to count the number of matches of values entered into nine individual cells.





Got a Question? Ask it Here in the Forum.