Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF

See how to use the SUMPRODUCT & SUMIF functions together to Lookup multiple items and add them in one cell. This method is great when you have many things to add from a column of lookup results, but you dont want the lookup column to use up space in the spreadsheet. Lookup Sum. Lookup Adding.

Category:

Science & Technology

Tags:

• Excel
• SUMPRODUCT
• SUMIF
• lookup
• adding
• Array
• Formula
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Lookup
• Sum
• Adding
• Accounting

[ExcelIsFun]

I do not know how to do it with a whole column filled with formulas.

[fressy98]

I have this formulas:

=SUMIF(raw!$F$2:$F$37;B13;raw!­$G$2:$G$37)+SUMIF(raw!$F$2:$F$­37;B13;raw!$H$2:$H$37)

and when I highlight each SUMIF one by one and press F9, the case will show the values. Example : =100+200

I have a whole column that I need it to display like that (=value+value)

Is there a way to do it faster instead one by one?

Thank you so much for the great video!

[ExcelIsFun]

Dear PrincessWithSkills,

Yes, paying attention is fun!

--excelisfun

[PrincessWithSkills]

Great video, I learned some, but according to your video #301, you can take the Lookup Cost column, take the right border and drag it to the right, and maybe copy it or drag it back, right click and Paste as Values Only. Then you can sum as you please. See, I am paying attention!