Counting values

[Eclipzan]

Hey i want to make a pillar diagram

this is the values:
X: weight = 1 amaunt = 4
X: weight = 2 amaunt = 2
X: weight = 3 amaunt = 4
X: weight = 4 amaunt = 2
X: weight = 5 amaunt = 4
X: weight = 4 amaunt = 2
X: weight = 3 amaunt = 4
X: weight = 2 amaunt = 2
X: weight = 1 amaunt = 2

Now i want to sort it so that the weight is horizontal, and stack if there are to of the same weight.
1. pillar named 1 with a value of 6 (4+2)
2. pillar named 2 with a value of 4 (2+2)
3. pillar named 3 with a value of 8 (4+4)
4. pillar named 4 with a value of 4 (2+2)
5. pillar named 5 with a value of 4 (4)
and if i was to change anything it would correct it self.

[mikerickson]

If you have weights in column A and amounts in column B, the formula =SUMIF(A:A, 1, B:B) will return the sum of the amounts associated with weight 1.

[Eclipzan]

ok i not sure how i sould do that so if you could do it in this?

[mikerickson]

In G11, put the formula =SUMIF($B:$B, RIGHT(G10,1),$C:$C) and then drag right.

[Eclipzan]

i have v. 2007 it says that there is a error in the formula would you mabye type it in and reply with the file attached?

[mikerickson]

That formula worked for me. Perhaps you could attach a file with the (erroneous) formula.

[Eclipzan]

remove the * in G11

but if you just make the file with the right formula then save it as a 2007 version it should be good

[mikerickson]

Removing the * and the formula works for me.

One possibility, you might try swapping the commas in thiat formula with semi-colons.
European notation can differ from American.

=SUMIF($B:$B; RIGHT(G10;1); $C:$C)

[Eclipzan]

now the formula is correct but it says #name?

[Cutter]

Remove the space before the RIGHT and the result is 4.

[Eclipzan]

Sorry but it does not work.
Is it because I have v. 2007?
=SUMIF() does not exist among the formulas I have available
=SUM() does
and i removed the space after $C:$C Still same error "#name?"

[oeldere]

See the file. It get as result 4.

[Eclipzan]

ok so it’s because I have another language pack(Danish) to me it looks like this: =SUM.HVIS($B:$B;HØJRE(G10;1);$C:$C)
This is what I was asking for to begin with. That one would make the file that is working for me to open.
But I want to thank you all for your trouble

[oeldere]

You can use this link to translate the formala.

It is also available for Danish.

http://www.applewood.nl/forms/3000/FRM-004/