Don- thank you for the clarification- I wasn't aware of the whole-column
limitation of Sumproduct. I've adjusted my formula, and now get #Value! in
a cell that I have confirmed should actually have a count (using "=a1=B17"
type checking to make sure I have exact matches). My revised formula,
which covers a large range just for testing purposes, is:

=SUMPRODUCT(('Raw Data'!$A2:$A30000=$C2,'Raw Data'!$B2:$B30000=K$1)*1)

I'm one step closer, since #Value! is better than #Num!, but I'm still
making quasi-random changes in the hopes that I'll magically come across
the right syntax. Any additional assistance you or other readers could
provide would be greatly helpful.

Try your formula this way...

=SUMPRODUCT(('Raw Data'!$A2:$A30000=$C2)*('Raw Data'!$B2:$B30000=K$1))

Rick