T
timmie7004
I have the formula below that sums the values in Range name
'Purchases' based on 2 criteria. How could I modify this to COUNT the
number of instances of receipts, based on the existing 2 criteria?
=(SUMPRODUCT((Store=123)*(Inventory_No=$I$6),(Purchases))/10)
I've tried =(COUNT((StoreNo=123)*(Inventory_No=$I$6),(Purchases))/10)
and =COUNT((SUMPRODUCT((StoreNo=123)*(Inventory_No=$I$6),(Purchases))/
10))
But they don't give me the correct answer
'Purchases' based on 2 criteria. How could I modify this to COUNT the
number of instances of receipts, based on the existing 2 criteria?
=(SUMPRODUCT((Store=123)*(Inventory_No=$I$6),(Purchases))/10)
I've tried =(COUNT((StoreNo=123)*(Inventory_No=$I$6),(Purchases))/10)
and =COUNT((SUMPRODUCT((StoreNo=123)*(Inventory_No=$I$6),(Purchases))/
10))
But they don't give me the correct answer