Make a formula shorter

[PatrikIden]

Hello, any budy know how to make this formula shorter:

Please Login or Register  to view this content.

Basicly ut's this code just repeted many times:

Please Login or Register  to view this content.

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[PatrikIden]

Hey, Thank's mate, That was realy helpful. I appreciate it.

[PatrikIden]

I also cant get this formula to work. In collumn A2:A99 i have names eg, Anna Boman and in AY2:AY99 i have prices. So i want to calculate the total price for Anna Boman. I have this formula that do not work, it calculates avery price from AY2:AY99.

Please Login or Register  to view this content.

The same name can accure several times.

[Jonmo1]

Try

SUMMA.OM(A2:A99;"Anna Boman";AY2:AY99)

[PatrikIden]

This seme to work, Is there a way to put the name before the sum? like Anna Boman "totalsum"

[Jonmo1]

You could do

="Anna Boman " &SUMMA.OM(A2:A99;"Anna Boman";AY2:AY99)

But then the result is just a text string, the sum value would be useless in further calculations.

I'd recommend keeping the Summa.Om formula in a cell by itself, say B2
Then in C2 do
="Anna Boman " & B2

[PatrikIden]

Thank's i'l try this. Is there a way for excel to automaticly pick the names in cell: A2:A99?
What i mean is that i want to automaticly put the different names in to the formula:

Please Login or Register  to view this content.