hi

=sumproduct(--(a2:a1000="name"),(b2:b100))

remove caps

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"VIC" escreveu:

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.