summing multiples lines in a vlookup function

R

Rob T.

I have a vlookup function within a spreadsheet that only pulls half of what I
need. The vlookup is pulling the first correct value based on the find
criteria instead of all items, so I need to create a function that will pull
all the exact matches and sum them together. Any help would be appreciated.

Thanks
Rob
 
L

~L

Sounds like you need Sumproduct.

Examples:
=Sumproduct(--($A$1:$A$50="Type A"),--($B$1:$B$50="Catfish"),$D$1:$D$50)

Or replace text with cell references:

=Sumproduct(--($A$1:$A$50=F1),--($B$1:$B$50=G1),$D$1:$D$50)
 
L

~L

You would use Sumproduct rather than VLookup.

Where Vlookup's Syntax is =VLOOKUP(Lookup Value, Lookup Rable, Column
Number, Range Lookup T/F)

Sumproduct's could be considered as:

=SUMPRODUCT(--(Lookup Range1=Lookup Value1),--(Lookup Range2=Lookup
Value2),--(Lookup RangeN = Lookup ValueN),Sum Range)

Having trouble finding the explanation I really like of the details of how
this works, but

http://www.exceluser.com/explore/sumproduct_12.htm

is a decent resource.
 

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

Top