Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF

Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
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.

[@excelisfun]

I am glad that the videos help!

[@LoveSong625]

Half of the video and already got what I wanted! Thanks!

[@excelisfun]

@HearIsRahul , I am glad that you like it!

[@mindpsyche]

Great videos Mike, I have learned a LOT from your videos, and the dueling net casts are a lot of fun as well.

[@excelisfun]

Dear PrincessWithSkills,
Yes, paying attention is fun!
--excelisfun

[@excelisfun]

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

[@celticmou5e935]

It worked, thanks for the trick

[@pechotina]

Great trick, thank you!

[@HearIsRahul]

Very use full is this

[@kukki19]

Great !!! video...thanks but it solved my half problem...suppose what will be the formula when you have not added the Column "E" and you have a grid with detail of Currencies.and you have to sum all the value as per grid. I am applying sumproduct but how can i create virtual vlookup for different value.
Your assistance valuable for me !!!
Thanks

[@EdwardLeeDesign]

Hi, amazing help so thanks for that. Question: How can you alter the final summed value, lets take the example in the video at 2:45, how would you get the say 50% of the contents of column N? =SUMIF(L13:L22,"Boom01",(N13:N22*0.5) did not work for me.

[@mimiho2935]

I'm trying to use Sumproduct with a criteria from a Vlookup column and the result return in "N/A" value. Ex ( sumproduct(--(condition range = "condition value", range1,range2..) . In this case, the "condition range" has all value from a Vlookup function. Is there anyway to do this productsum?

[@josebetancourt5890]

Hello!! Excellent video! I had a very similiar situation in my job and that example helped me to get the solution. My question, the sumproduct can handle the sumifs function as well?.
Again thanks a lot!!

[@ajitrawat8972]

Hii i want sum value same code with different different row one sheet to second sheet but it is not show total value of particular item..
Plzzz revert ASAP

[@josepheffiom8510]

Hi I'm looking for the download link for the file Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF. Can anyone help? I watched the video and found this to be very helpful. I would like to try it out.

[@Maredream]

I never fking understand your videos. Jumping back and forth like this is just confusing.