Download Excel Workbook
Table of Contents
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.
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
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.
