Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
How do I set up a countif, or sumif that is multiconditional? | Excel Worksheet Functions | |||
problems with sumif and countif | Excel Discussion (Misc queries) | |||
Reference Cells with Sumif or Countif | New Users to Excel | |||
Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions |