unique SUM

[kaveh]

I have three columns,. first column contains a list of items, and the
second one is the description of the first column, and the third one is qty
of each item. specific items may be repeated multiple times within the first
column,
how could I get the unique SUM of each item?

 

[Mike H]

Maybe this

=SUMPRODUCT((A1:A30="Coats")*(B1:B30="Red Ones")*(C1:C30))

Obviously changed to match what you are looking for in columns A & B.

Mike

 

[T. Valko]

Try something like this:

=SUMIF(A1:A100,"item1",C1:C100)

Or, better to use a cell to hold the item name:

E1 = item1

=SUMIF(A1:A100,E1,C1:C100)

 

[kaveh]

Thanks for your time, actualy lets make it two columns, one in the item, and
second is the qty of each item, by using the formula below I have the unique
list if items of the first column, but each itme has diffrent quantity and
repeated lots of time, I want to get the total sum of each unique item

{=INDEX($A$3:K$200,MATCH(TRUE,ISERROR(MATCH($A$3:$A$200,$M$2:$M2,0)),0),1)}

 

[Mike H]

Hmmm,

I have three columns,. .....

sometimes you hit em sometimes you don't

Mike

 

[kaveh]

You did it.

 

[kaveh]

=SUMIF(A1:A100,E1,C1:C100)
It worked for me

 

[Mike H]

and i would have suggested something along those lines for 2 columns

 

[T. Valko]

You're welcome!

 

[Ashish Mathur]

Hi,

you may also want to use Data > Subtotals

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com