Using *AND -- is totally redundant.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike H" wrote in message
...
Possibly

=SUMPRODUCT(--(Store=123)*--(InvID=16)*--(Purchases0))



Mike

" wrote:

See below, answer I should get is 2 (receipts of the inventory line)

Store InvID Opening Purchases
123 16 4730 0
123 16 2900 0
123 16 2150 2500
123 16 3870 0
123 16 2950 2750
123 16 5120 0
123 16 4150 0
525 16 6500 0
525 16 4650 0
525 16 4020 0
525 16 3070 0
525 16 2220 1800
525 16 3450 1200
525 16 3880 0