Add values with same code

[rodolform]

I have a ws with two columns one with a value and other with a code,
want to add all the values with the same code, any ideas????

value code
14 1
21 2
14 1
16 1
21 2

Result for code 1=44
Result for code 2=42

I'll have about 10 different codes.

Thank you
Rodolf

 

[Don Guillett]

Have a look in HELP index for SUMIF

 

[rodolform]

Thank you for your reply.

I'm using =sumif(a2:a10,1,b2:10) but get a NAME error back, what I'
doing wrong???

Rodolf

 

[Peo Sjoblom]

Do you have English language Excel?

 

[Don Guillett]

sumif(a2:a10,1,b2:10) but get a NAME error back, what I'm

Think about where you are using your criteria?
and you left out the A in your range

 

[rodolform]

No, I use excel in spanish, but have a function translator where SUMI
= SUMA.S

 

[rodolform]

got it.....

It results that my function translator has a mistake because SUMIF
SUMAR.SI I was missing an R in the function name.


Thank you all for your help.:

 

[Don Guillett]

glad to help