SEARCH A NAME ON COL A & SUM THE VALUES ON COL B

V

VIC

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.
 
M

Marcelo

hi

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

remove caps

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



"VIC" escreveu:
 
M

Marcelo

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

sorry I forgot one 0 on the previous post

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



"Marcelo" escreveu:
 
Top