Add values with same code

R

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
 
R

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
 
R

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.:
 
Top