Yep, I certainly overlooked that!

"Harlan Grove" wrote:

"JMB" wrote...
Or you could eliminate the IF statement completely
=SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C5)*1,
('Raw Data'!$B$2:$B$30000=I$1)*1)
....

Or eliminate a few unnecessary characters,

=SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C5)*('Raw Data'!$B$2:$B$30000=I$1))