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

Поділитися
Вставка
  • Опубліковано 2 гру 2024

КОМЕНТАРІ • 22

  • @vitornizkia5305
    @vitornizkia5305 12 днів тому

    This is very helpful and very simple😁👍

  • @mocam4636
    @mocam4636 8 місяців тому +2

    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

  • @johnny07652
    @johnny07652 Місяць тому

    AWESOME!!! Thanks so much!!!!

  • @aashikaraj72
    @aashikaraj72 Місяць тому

    Haven't seen any other explainer this good tysm

  • @georgebasalic9425
    @georgebasalic9425 8 місяців тому

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

  • @IvanCortinas_ES
    @IvanCortinas_ES Рік тому +1

    Excellent techniques. Thank you Chester.

  • @hikmatmarashdeh2293
    @hikmatmarashdeh2293 Рік тому

    really amazing illustration. many thanks !

  • @johnaynejian8122
    @johnaynejian8122 Місяць тому

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

  • @ThePktabassum
    @ThePktabassum 4 місяці тому

    Thank you for this great video.

  • @DavidScott-27
    @DavidScott-27 Рік тому

    Simply awesome! Great help to me, thanks.

  • @ausdeanhardman
    @ausdeanhardman Рік тому

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

  • @alexzhlebinkov3966
    @alexzhlebinkov3966 7 місяців тому +1

    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

  • @thomasfitzpatrick8987
    @thomasfitzpatrick8987 Рік тому

    Really useful and well explained. Thank you.

  • @iqbali.hashem
    @iqbali.hashem 6 місяців тому

    thanks, its very helpful

  • @manissery1956
    @manissery1956 Рік тому

    EXCELENT

  • @revolnz
    @revolnz 7 місяців тому

    Thank you.

  • @ericspero879
    @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?

  • @Mohamed77779
    @Mohamed77779 4 місяці тому

    thanks a lot

  • @khammonthsybounheung
    @khammonthsybounheung 10 місяців тому

    merci

  • @manissery1956
    @manissery1956 2 місяці тому

    🎉