XLOOKUP Sum of All Matches Using Excel | XLOOKUP or SUMIF? | XLOOKUP or SUMPRODUCT?

[@aashikaraj72]

Haven't seen any other explainer this good tysm

[@mocam4636]

I love you, you just saved me so much time. Now I can go home to my wife and child and spend time with them

[@georgebasalic9425]

Hi thank you for your tutorial, it was very helpful.

[@IvanCortinas_ES]

Excellent techniques. Thank you Chester.

[@ChesterTugwell]

Many thanks Ivan

[@ThePktabassum]

Thank you for this great video.

[@hikmatmarashdeh2293]

really amazing illustration. many thanks !

[@DavidScott-27]

Simply awesome! Great help to me, thanks.

[@alexzhlebinkov3966]

Hi Chester thanks for that tutorial, for the second example what if let’s say Barbara had two separate columns, how would you then sum this up with x look up? I am at a spot where my look up value occurs more than once and x look up only looks up the first one it comes across.Thank you

[@ausdeanhardman]

TOP tip here, thanks mate. This has helped a lot.

[@thomasfitzpatrick8987]

Really useful and well explained. Thank you.

[@iqbali.hashem]

thanks, its very helpful

[@ericspero879]

Super helpful. However, I cannot get this to work when I have an array of values to sum. For example, in your Example 1 if you had multiple columns of scores or in your Example 2 if you had numerous additional rows with each sales period occurring multiple times. Am I in need of a different function?

[@revolnz]

Thank you.

[@Mohamed77779]

thanks a lot

[@khammonthsybounheung]

merci

[@manissery1956]

EXCELENT

[@manissery1956]

🎉