Don McLean wrote...
I recieve a #NUM! error

Then you're not using Jacob's formula OR you have a #NUM! error in one
of your cells. What's the formula you're actually using?

"Jacob Skaria" wrote:
Assume the data range is A1:B100 with headers in Row1.

With the query name in C2 and item in D2 try the below formula

=SUMPRODUCT(--(A2:A100=C2),--(B2:B100=D2))
....