How to use SUMPRODUCT WITH IF CONDITION(S) in EXCEL

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • How to use SUMPRODUCT WITH IF CONDITION(S) in EXCEL
    =SUMPRODUCT(--($B$3:$B$12="Nicola"),$D$3:$D$12,$E$3:$E$12)
    #excel
    #exceltips
    #exceltutorial

Комментарии • 12

  • @realmehranvahedi
    @realmehranvahedi  8 месяцев назад

    Dear awesome viewers!
    Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now!
    I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions.
    Your support means the world to me. Let's keep the conversation going!
    Thank You!

  • @TrongYangLim
    @TrongYangLim Месяц назад +1

    Thank you very much for the super helpful video. Your kind effort is deeply appreciated.

    • @realmehranvahedi
      @realmehranvahedi  Месяц назад

      Hi @TrongYangLim , Thank you so much for your kind words! I'm thrilled to hear that you found the video helpful. If you have any questions or need further clarification on any points, please don't hesitate to ask. Looking forward to hearing from you again!

    • @TrongYangLim
      @TrongYangLim Месяц назад +1

      @@realmehranvahedi 🥰

  • @luisvayas6657
    @luisvayas6657 Год назад +2

    Hello, thanks for the video, very helpful.

  • @Julianfckl
    @Julianfckl 5 месяцев назад +1

    Hi, thank you for the video and explanation.

    • @realmehranvahedi
      @realmehranvahedi  5 месяцев назад

      Thanks so much for your kind words! I'm really glad you found the video and explanation helpful. Stay tuned for more content, and if you have any specific topics or questions you'd like me to cover in future videos, please let me know. Your support and curiosity are what keep this channel going!

  • @gertzen9019
    @gertzen9019 7 месяцев назад +1

    Thanks for sharing. Just what I needed.

    • @realmehranvahedi
      @realmehranvahedi  7 месяцев назад

      Thanks for the comment. I'm glad you found it useful. Keep visiting my channel for even more neat Excel tips and tricks.

  • @alessandrorosati969
    @alessandrorosati969 Год назад +1

    How make the loop for the sumproduct function in excel?

    • @realmehranvahedi
      @realmehranvahedi  Год назад

      Hello Alessandro, thanks for the comment. Can you articulate what you mean by loop? Do you have an example?