Master Excel's SUMPRODUCT Formula



Quickly learn how Excel’s SUMPRODUCT formulas works.
Download the workbook:

Get the full course:

Advanced Excel: Master Excel’s SUMPRODUCT Formula

This video is part of a series that belongs to my Advanced Training course called “Advanced Excel: Top tips and formulas”.

The classical use of Excel’s SUMPRODUCT function is to do a sum of multiplications. The good thing about SUMPRODUCT is that it can work on arrays of values and it doesn’t have to be entered as an array function so no need to do control + shift + enter (CSE).

The great thing about SUMPRODUCT, is that it can help solve many more problems in non-obvious ways. It can act as a conditional SUMIFS function or work as a lookup function as INDEX and MATCH does. It can also act as a COUNTIF function.

SUMPRODUCT is also a better SUMIFS, because it can check for OR conditions – which the SUMIFS can’t. SUMIFS can only check for AND conditions.

In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you from unnecessary “workarounds” in your Excel files. It will also show you the SUMPRODUCT formula in slow motion.

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Get Office 365:
Microsoft Surface:

GEAR
Camera:
Screen recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:
Twitter:
LinkedIn:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Nguồn: https://federicobellucci.net/

Xem thêm bài viết khác: https://federicobellucci.net/cong-nghe/


Article Categories:
Công Nghệ

Comments

  • holy sweet jesus, this channel is i am looking for

    H M Aulia July 24, 2020 2:19 pm Reply
  • Just wow. Super job. Thank you

    Inv Great July 24, 2020 2:19 pm Reply
  • Brilliant!

    Daniel Mathivathan July 24, 2020 2:19 pm Reply
  • Thanks

    FRANKWHITE1996 July 24, 2020 2:19 pm Reply
  • the more i watch this channel the more i dont know what formular i have to go for at first. lol

    jlelelr July 24, 2020 2:19 pm Reply
  • Great Leila !!!

    pieter karunia deo July 24, 2020 2:19 pm Reply
  • Thank you for the tutor! Very Helpful!

    吳君傑 July 24, 2020 2:19 pm Reply
  • Hi, I just found gold mine of excel info I was missing. I am really thankful for sharing all these info.

    Naboulsi Khalid July 24, 2020 2:19 pm Reply
  • Hi Leila, what if instead of text in column A (Company A) you have numbers (product code for instance)? Does sumproduct still works?

    catalin ciofu July 24, 2020 2:19 pm Reply
  • Hi
    Please can you tell my how can i count a particular text in a column excluding certain rows , eg rows s2:s500 and count rows that say on track excluding text in row s4 / s13/s18

    Mildred Souza July 24, 2020 2:19 pm Reply
  • Fabulous

    I have a question if you don't mind

    I'm working with a Gantt chart via excel. I want to calculate the overall project percentage. As you know, in the Gantt chart we have tasks and subtasks. How can I calculate the overall project percentage? To make it more interesting, how can I skip one or more tasks from the calculation by sumproduct formula?

    I wish if I can send you the file to make it clearer

    عازف عود July 24, 2020 2:19 pm Reply
  • Very well done. Thank you.

    Victor Platon July 24, 2020 2:19 pm Reply
  • Woooow, You’re Brilliant!

    Wael Omer July 24, 2020 2:19 pm Reply
  • Excellent !

    Engr Monirul Islam July 24, 2020 2:19 pm Reply
  • I love u

    Aditya Kumar July 24, 2020 2:19 pm Reply
  • U open my eyes..u r awesome..always

    Akshay Chodankar July 24, 2020 2:19 pm Reply
  • Hi a small suggestion
    Can you please put a serial number to each of your video which will be helpful for tracing . You may refer the past video based on the serial number ..eg please refer my video #30 for sumifs etc…

    sandy Nair July 24, 2020 2:19 pm Reply
  • This is a great video I haven't seen before this kind of video on YouTube ! You done a great many of people learn lots of thing just because of you ❤️

    mayank kapoor July 24, 2020 2:19 pm Reply
  • Your tutorials are really agitating my brain …………..Your way of explaining really clears every query and possibilities of using such functions Thanks

    PRASANNA PRASANNA July 24, 2020 2:19 pm Reply
  • Thank you very much

    AMAN JAJOO July 24, 2020 2:19 pm Reply
  • Learnt something new

    Shaikh Azher July 24, 2020 2:19 pm Reply
  • classy explaination

    Shaikh Azher July 24, 2020 2:19 pm Reply
  • You explained this so articulately, made it really easy to understand. Thank you so much!

    Anh Kim Nguyen July 24, 2020 2:19 pm Reply
  • I instantly bought your product after watching this

    dheeraj sharma July 24, 2020 2:19 pm Reply
  • madam it is so very good. Very helpful. Stay safe

    Himanshu Gupta July 24, 2020 2:19 pm Reply
  • I'm going go drink a 24oz. can of Malt Liquor

    Mackenzie Jefferson July 24, 2020 2:19 pm Reply
  • Leila, you are far excellent and i am one of your admirers. I too have created a video on how to use vlookup without using keyboard, kindly check and request the support 😊
    https://youtu.be/GEx6dyMroYk

    HR Talk's July 24, 2020 2:19 pm Reply
  • Awesome explanation and high quality content

    Education July 24, 2020 2:19 pm Reply
  • Absolutely exceptional way of teaching …. Thanks a lot Mam …. I tried your free exercise book … except for count for all the other I have cross checked the answer and it matches … I don't know where I make the mistake for count … I used the formula =SUMPRODUCT(((E4:E29>6)+(F4:F29<2000))*(E4:E29>6)*(F4:F29<2000)) and getting answer 4 but for the given criteria is 2 … please advice…
    Thanks a lot again ….

    VENKAT IYER July 24, 2020 2:19 pm Reply
  • WOW! It's a much better formula than countif/ sumif. Learned it last year from your video. But went back to old habit without even realizing. Good to rediscover this gold nugget.

    Ziaur Rahman July 24, 2020 2:19 pm Reply
  • Is there any way I can add up a certain product in a list of many different items?

    TruthofDilly July 24, 2020 2:19 pm Reply
  • This is almost a miraculous formula, thanks

    Anurag Mohan July 24, 2020 2:19 pm Reply
  • It's better than online courses

    ιF ß July 24, 2020 2:19 pm Reply
  • fantastic explanation!!! Many thanks!!

    Tushar Varun July 24, 2020 2:19 pm Reply
  • VERY NICE

    The Interior Exterior Ahmedabad July 24, 2020 2:19 pm Reply
  • Excellent but if you had zoomed in the video it would have been easier to see the syntax.

    Arshad Ali July 24, 2020 2:19 pm Reply
  • Just found this video and it's very helpful. This is a relatively unknown but elegant and powerful function.

    Spudgun81 July 24, 2020 2:19 pm Reply
  • You are a genius and a life saver thanks

    barry heeney July 24, 2020 2:19 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *