summing all results in a vlookup

V

Valerie

I need to sum all of the values in a vlookup formula. Currently the formula
only brings the value over for the first item that is found. It does not
continue to search the table for additional values and sum all of the values
together.

Any help would be appreciated.
 
C

Chip Pearson

Rather than VLOOKUP, take a look at the SUMIF function.

=SUMIF(range_to_search,match,range_to_sum)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

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

Sum Values from different column 1
Searching the formula (not the value) for a text string 1
VLOOKUP or SUMIF for Multiple Criteria 2
VLOOKUP duplicate values in table the table array? Help me solve 1
Vlookup to reference offset 1
summing multiples lines in a vlookup function 5
Sum every Nth Row (almost working) 2
SumIf and vlookup formula help 2

Top