COUNT based on 2 criteria
So that formula checks where column A = 126 and Inventory_N o = I6, pure and
simple.
Can you post an example dataset that calculates wrongly?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
...
Bob, Store is in Column A; and Purchases in Column F
|