Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF

[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]

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

[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!

[ExcelIsFun]

Dear PrincessWithSkills,

Yes, paying attention is fun!

--excelisfun