I have the following data:
Unit Criteria
4b 4
6b 1
4b 1
6b 2
4a 1
4b 1
6b 3
6b 1
4a 1
6b 5
I need to know how many times 4b (and 4a and 6b) has each of five criteria (1,2,3,4 or 5). I was looking at SUMPRODUCT that I have used to count criteria that are text, but it doesn't work for numeric criteria.
Can anyone help?
Thanks.
Mike
Bookmarks