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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

remove caps

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



"VIC" escreveu:
 
=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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
SUM Q 2
Lookup Formula 4
Triple IF? 2
lookup/match mult values 3
Count columns that meet criterias 3
vlookup backward 8
calculated celles according to more then 1 condition 5

Back
Top