This is giving me a #NAME? Error, any ideas?


"Duke Carey" wrote:

=SUMPRODUCT(--(A1:A100000=B16),--(B1:B100000=L23))

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please