average based on condition same cell

[Odeen]

Hi,

please help me out with this function. I have summary of orders like bellow.
What i can tell to this is, that shipping prices are same for all AA orders in here. So i need to do average for every same names, which will be divided by Shipping price.
I have maximum 5 same Names... if this information helps you out.......

A1 Name | B1 Qty | C1 Shipping | D1 average function
aa | 1 | 1000 | something like =if(A2=A3;C2/Average(B2:B3)
aa | 3 | 1000 |
bb | 2 | 2000 |

Thanks for your helping me out......

[AndyLitch]

=SUMPRODUCT((A2:A5000="aa")*(C2:C5000))

That will total all shipping to "aa"........ Is that what you're looking for?

[Odeen]

Hi,

srry, i think not... because what i want and dont know is......

if there is some function to count all same names like "aa", but this "aa" i dont want to set anywhere....
it needs to be declared universaly....not everytime type "aa", "bb", etc........ i have here about 500 various names

[Odeen]

The only thing i know, but i need to do some steps is of creating contingent table, to left column put "names" to values put summaries of Qty. Then copy this contingent table to normal table and make the shipping be divided by Qty.......

but it is plenty of steps......

if there is some function, i ll be gratefull...

[AndyLitch]

If you can create a separate list of unique names then =SUMPRODUCT((A2:A5000=B2)*(C2:C5000)) might work for you where B2 holds the name to sum... That can be pasted down the list but don't forget to absolute the range values