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

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.

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

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.

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

=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:

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.

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

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