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 WORKBOOK

HELPFUL RESOURCE:

If you like this Excel tip, please share it

Facebook

Twitter

Google+

INDIRECT Function Using Sheet References What does it do? Returns a reference to a cell, or a range of cells of a sheet. Formula breakdown: =INDIRECT(ref_text, ) What it means: =INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FALSE if it is a R1C1 style) The ...

Vlookup Approximate Match in Excel What does it do? Searches for an approximate value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) Wha...

Calculate Total Sales With An Array Formula An Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data. This could be a range of cells, a worksheet reference or a defined name. One of the most popular uses of an array formula is to calculate Total Sales. ...

Excel Subtotal Function – Include Hidden Val... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...