=Sumif(A1:A100,"NAME",B1:B100)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"VIC" wrote in message
...
ON COLUMN A I HAVE A NAME ON SEVERAL ROWS. ON COL B I HAVE DIFFERENT
VALUES
FOR THAT SPECIFIC NAME. I HAVE TO ADD THIS VALUES ON COL B FOR THAT
SPECIFC
NAME.