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+

VLOOKUP Multiple Columns What does it do?Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array.Formula breakdown:{=SUM(VLOOKUP(lookup_value, table_array, {col_index_num1,col_index_num2}, ))}...

SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function. It allows you to Sum the values in a range that meet a criteria that you specify.So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...

INDEX Function with Data Validation To make the INDEX function in Excel interactive we can add a Data Validation drop down list.By referencing the second argument in the INDEX function - the Row Number - to a data validation list, will allow a user to choose the nth position of a list and return their respectiv...

Sum a Range Using the INDEX Function You can sum a range of values within a table using the INDEX function in Excel. This is valuable when you want to extract key metrics from a table and put them in an Excel Dashboard.To make this work you firstly need to start your Excel formula with the SUM function foll...