Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum If - How to sum for ranges meeting certain criteria
I have the following data:
Col D Col E Col I Part Numbers Part Unit Cost Extended Value Question 1: How do I sum the number of unique parts in the following ranges (<=$25, $26-50, $51-100, $101-$500, $501-1,000, $1,001)? I was able to do it by part, but not unique part. I am trying to avoid duplicates. Question 2: How do I sum the dollar value associated with those ranges? So I would be able to say I have 10 unique parts in the <$25 category, with a total extended value of $XXX (this should include the duplicate parts since I am trying to get a total value). I have been playing with this and can't seem to get it to work. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum If - How to sum for ranges meeting certain criteria
Do you want a SUM or a COUNT?
Can you post a small sample of data and tell us what result you expect? -- Biff Microsoft Excel MVP "Corrina" wrote in message ... I have the following data: Col D Col E Col I Part Numbers Part Unit Cost Extended Value Question 1: How do I sum the number of unique parts in the following ranges (<=$25, $26-50, $51-100, $101-$500, $501-1,000, $1,001)? I was able to do it by part, but not unique part. I am trying to avoid duplicates. Question 2: How do I sum the dollar value associated with those ranges? So I would be able to say I have 10 unique parts in the <$25 category, with a total extended value of $XXX (this should include the duplicate parts since I am trying to get a total value). I have been playing with this and can't seem to get it to work. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumProduct meeting two criteria | Excel Worksheet Functions | |||
Sum Product values meeting 2 criteria | Excel Worksheet Functions | |||
Sumif problems - meeting 2 criteria then sum | Excel Discussion (Misc queries) | |||
how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions |