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+

Excel´s TEXT Function The TEXT function in Excel allows you to convert a numeric value to a specific format by using special format strings.If you have a date and want to show just the month or if you have a large number and want to show it in a thousands format , then the TEXT function is your sa...

Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set. For example, you can calculate the number of time a sales rep has made sales in a particular region. Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function....

VLOOKUP Example: Vlookup with a Drop Down List 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(thi...

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:1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...