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+

Sumproduct & Weighted Averages What does it do? It returns the sum of the products of corresponding ranges or arrays Formula breakdown: =SUMPRODUCT(array1, , ...) What it means: =SUMPRODUCT(this array, with that array…) A quick way to calculate the weighted average of two lis...

Excel Subtotal Function – Filtered or Visible Valu... 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...

Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color. This is how it is done: STEP 1: Select all the cells in your Excel worksheet by clicking on the to...

Named Ranges with Vlookup Formula What does it do? Searches for a 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, ) What it means: =VLOOKUP...