Using SUMPRODUCT With The IF Function To Create A Conditional Formula In Excel

• Creating The STDEV IF ...
If you like this video, enroll now to receive UNLIMITED LIFETIME ACCESS to more than 800+ videos, 1,500+ downloadable files, certificate of completion, and unlimited access to ALL future content.
As Microsoft Excel releases new functions and formulas, you will automatically receive access to the videos, so you won't need to purchase multiple courses to get new updates/features.
Harvard asked him to create their course and Microsoft asked him to write their book. In this video, Dr. Winston discusses how to use the SUMPRODUCT with IF function to create a conditional formula in Excel. Here, we will illustrate one important application of the SUMPRODUCT function: the ability to filter data instead of the IF function.
If you like this video, it comes from his Excel 2019 book, you can get it here:
Excel Data Analysis and Business Modeling 👉👉 amzn.to/30a2MbV
Marketing Analytics 👉👉 amzn.to/2FRng2l
Analytic Stories 👉👉 amzn.to/366IiVl
Follow us on social media:
LinkedIn 👉👉 / excel-with-wayne
Facebook 👉👉 / excelwithwayne
Instagram 👉👉 / excel_mastermind
To follow along to this video with the starting and ending files, you can download the files here:
Start File 👉👉 bit.ly/3GfHzQ4
Finish File 👉👉 bit.ly/3gg3I6b
Free 21-Day course 👉👉 bit.ly/3jeXSSC
*Some of the links and other products that appear on this video are from companies which we will earn an affiliate commission or referral bonus.
*Dr. Winston created the course for Harvard, but is not affiliated with the university.
#EXCEL #MICROSOFTEXCEL #MICROSOFTOFFICE #EXCEL2019 #OFFICE365 #ANALYTICS #EXCELTIPS #EXCELTRICKS #EXCELHACKS #TOPEXCELTIPS #BI #DATA #BIGDATA #DATAANALYSIS #EXCELTUTORIAL #MICROSOFTEXCELTUTORIAL #TIMESAVINGEXCELTIPS #ARRAYFORMULASANDFUNCTIONS #ARRAYFORMULAS #ARRAYFUNCTION #SUMPRODUCTIF #MICROSOFT_EXCEL #MICROSOFT_OFFICE #EXCEL_2019 #OFFICE_365 #EXCEL_TIPS #EXCEL_TRICKS #EXCEL_HACKS #TOP_EXCEL_TIPS #BIG_DATA #DATA_ANALYSIS #EXCEL_TUTORIAL #MICROSOFT_EXCEL_TUTORIAL #TIME_SAVING_EXCEL_TIPS #ARRAY_FORMULAS_AND_FUNCTIONS