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

Advanced Sumproduct_Conditional Date

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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...