=SUMPRODUCT(--(A1:A100=22),--(B1:B100=62))
You can have the '22' and '62' in two cells, say C1 and D1,
=SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1))
then you can get different results by changing those two cells and not have
to edit the formula,
Regards,
Alan.
wrote in message
ups.com...
I need to be able to find the number of occurrence of certain type of
product sold at a certain price.

eg.
I have 2 columns.

Col A = Product Code
Col B = Selling Price

Prd Code Price
2 £1.00
9 £62.00
13 £5.00
17 £5.00
17 £5.00
17 £124.00
17 £62.00
17 £62.00
17 £5.00
18 £5.00
20 £5.00
20 £5.00
21 £62.00
21 £5.00
21 £62.00
21 £5.00
21 £5.00
21 £62.00
21 £5.00
21 £5.00
21 £62.00
21 £62.00
22 £5.00
22 £5.00
22 £5.00
22 £62.00
22 £5.00
22 £63.00
22 £5.00
22 £62.00
22 £5.00
22 £62.00
22 £5.00
22 £5.00
22 £5.00
22 £62.00
22 £5.00
24 £62.00
24 £62.00
24 £5.00

I need to be able to find how many of 22 are sold at £62, £5 and how
many of 17 are sold at £62, £5 etc.

is there an equation to solve this? I could only use countif to count
the total number of products that are sold at £62, £1,£5 etc but I
dont know how many of 22 are sold at £5, how many 17 are sold at £5.

thanks.