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...
RohanAbaHK May be you want SUMIFS(). Try-
=SUMIFS($H$4:$H$15,$G$4:$G$15,B4)In case to refer sheet2 use-
=SUMIFS(Sheet2!$H$4:$H$15,Sheet2!$G$4:$G$15,B4)
- Thank you for sharing. I think this works.
