Pinterest Pixel

Advanced SUMPRODUCT Function: Conditional Date

John Michaloudis
Free Practice Workbook
Advanced SUMPRODUCT Function: Conditional Date.
If you want to find out the total sales for a particular month, then the SUMPRODUCT function is your answer.  You can create a criteria for a specific date range, a particular month or a year.
Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline

In the example below I show you how to use the SUMPRODUCT function to sum up the total sales for a particular month.

download workbookAdvanced-Sumproduct_Conditional-Date.xlsx

 

 

If you like this Excel tip, please share it
LinkedInCopyPrintReddit
Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to fix the #NAME error in Excel?

Steps To Follow

Excel Formulas & Functions TutorialsExcel Math FormulasSUMPRODUCT Formula in Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!
Share to...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly