Forum Discussion
Solved
VLOOKUP with multiple answers provide one total in cell?
How do I create a formula to look at another tab, say HOPPERS, and pull any 'total value' column total(s) when i have it look at a specific part which can be listed more than once on the HOPPER tab? ...
you should use it like this.
SUMIF is faster than SUMPRODUCT
=IF(LEFT(A2,6)="Serial","",SUMIF(HoppersResin,A2,HoppersTotal))plz make sure that your named ranges have equal number of rows in both named ranges used in the formula.
Hi Teresa,
Do you mean something like this?
Yes, what formula would I use?
Hi Teresa,
For this sample the formula is
=SUMPRODUCT(($A$2:$A$80=$F2)*$B$2:$B$80)
you only shall adjust the ranges.
Sample is attached.
Sorry, a little confused. Wouldn't this be more of a nested formula with SUM and also VLOOKUP? Where a cell looks up another tab of information and sums all items matching a certain criteria?
