Forum Discussion
VLOOKUP PULLING TOTAL SUM FROM A MULTIPLE RAWS
Hello there. Need help pls. I want to know, how I can pull out the total SUM of multiple rows by VLOOKUP. With VLOOKUP, I look up for the value (Example Invoice number ADL01) in sheet 1 and pull...
=SUMPRODUCT(($A$4:$A$13=A17)*$B$4:$B$13)Alternatives could be SUMPRODUCT, Power Query and a Pivot Table.