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

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

[@youdothemaths]

Very clear and concise. Thank you.

[@georgebasalic9425]

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

[@aashikaraj72]

Haven't seen any other explainer this good tysm

[@IvanCortinas_ES]

Excellent techniques. Thank you Chester.

[@ChesterTugwell]

Many thanks Ivan

[@johnny07652]

AWESOME!!! Thanks so much!!!!

[@hikmatmarashdeh2293]

really amazing illustration. many thanks !

[@vitornizkia5305]

This is very helpful and very simple😁👍

[@johnaynejian8122]

Brilliant - thank you so very much!!!! Liked and sub'ed!

[@ChesterTugwell]

Thanks for the sub!

[@DavidScott-27]

Simply awesome! Great help to me, thanks.

[@ThePktabassum]

Thank you for this great video.

[@bobbyjordanregaton1800]

Thank you so much.

[@ausdeanhardman]

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

[@thomasfitzpatrick8987]

Really useful and well explained. Thank you.

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

[@iqbali.hashem]

thanks, its very helpful

[@revolnz]

Thank you.

[@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?

[@Hari-n4f]

EXCELENT

[@Mohamed77779]

thanks a lot

[@khammonthsybounheung]

merci

[@Hari-n4f]

🎉