That is how that SP formula works. without seeing your data I cannot say why
you get 7 or why you think you should get 2, but assuming Store is column F,
and assuming the formula that you posted woks, this is the same, it just
doesn't multiply by the number of purchases or divide by 10.

--
---
HTH

Bob


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



wrote in message
...
Just tried that, answer = 7, but should be 2

If I have 10 columns of data and the range name 'Purchases' is in
Column F, how would the formula count the number of receipts, for
Store 123 and Inventory_No in I6, or am I missing something?