Forum Discussion

Teresa Smagacz's avatar
Teresa Smagacz
Copper Contributor
Mar 12, 2018
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? ...
Formulas & Functions
Show and Tell
  • Jamil's avatar
    Jamil
    Mar 13, 2018

    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. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 12, 2018

Hi Teresa,

 

Do you mean something like this?