Pinterest Pixel

Advanced SUMPRODUCT Function: Conditional Date

If you want to find out the total sales for a particular month, then the SUMPRODUCT function is... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

Advanced SUMPRODUCT Function: Conditional Date | MyExcelOnline
download workbookAdvanced-Sumproduct_Conditional-Date.xlsx

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

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!