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.