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.
I have defined names for the columns, but the following formula provides an #VALUE! error within cell:
=IF(LEFT(A2,6)="Serial","",SUMPRODUCT((HoppersResin=Resin!A2)*HoppersTotal))
HoppersResin is product column from the Hoppers tab.
HoppersTotal is grand total column from the Hoppers 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.