I need to find a correct formula that solve this issue. I have 2 columns (Age and Diagnosis). I need to count the number of times a "specific" diagnosis (X) appear among certain age group (<20, 20-50, >50). I think it should be a sumproduct formula but I am not sure how to formulate it.
Here is an example of he spread sheet
Age Diagnosis
10 X
14 X
34 Y
22 Y
55 Z
29 Z
60 X
Thanks in advance for your help
Here is an example of he spread sheet
Age Diagnosis
10 X
14 X
34 Y
22 Y
55 Z
29 Z
60 X
Thanks in advance for your help
Last edited: