Pinterest Pixel

Advanced SUMPRODUCT Function: Conditional Date

Advanced SUMPRODUCT Function: Conditional Date If you want to find out the total sales for a particular... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline

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

 

 

If you like this Excel tip, please share it
Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline

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...