I have read through the other threads on this topic and understand the use of SumProduct when want the count for all the rows in a given column. What I need is to be able for each SubTotal (I have ~3000 rows, yielding ~750 different subtotal rows). What I want is to have a separate count for each of the 750 subtotals, of within the group, how many contained a particular value. For Example, I am counting Column G which has values A, B, C, D. So if for one subtotal, I have a total of 10 rows (A,B,A,C,D,A,B,A,C,D), I want a count of only the number of those 10 rows, that contained the letter A in Column G. I would want the subtotal to be 4. Is this possible?