sumif and countif nested?
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.
|