I'm trying to use excel to count how many cells within a specified range are blank, based on whether a different range matches a third range. Example below:
1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5
75 p143 4 234 x43 4 43 332 1 1 1 1 43 5 23 33
Above is my data
1 2 3 4 5
I want then for excel to count how many cells in row 2 are not blank, when row 1 is equal to 1, 2, 3, 4, 5, etc.
Thoughts??
Bookmarks