Advanced SUMPRODUCT Function: Conditional Date

DOWNLOAD OUR
FREE EXCEL GUIDES

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 WORKBOOK

HELPFUL RESOURCE:

If you like this Excel tip, please share it

Facebook

Twitter

INDEX-MATCH Maximum Sales The INDEX-MATCH formula cannot only look up values to the left and right of your data but its versatility means that it can also lookup the largest values within an array. Say that you had a list of Sales Reps in one array and their corresponding Sales Values in another array....

Create a Dynamic Data Range with the OFFSET functi... What does it do? It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cells Formula breakdown: =OFFSET(reference, rows, columns, , ) What it means: =OFFSET(start in this cell, go up/down a number o...

IFERROR Function: Introduction What does it do? It returns a value that you set if a formula has an error Formula breakdown: =IFERROR(Value,Value if Error) What it means: =IFERROR(The Formula,What do you want to show if The Formula has an error?) If you have a calculation tha...

Top Excel Formulas & Function Examples To Get... Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more. DATE & TIME DateDif EndOfMonth Time Weekday Workday ...