Hello everyone,

I have been researching for hours but cannot get this to work. My goal is to sum the amounts of invoices from column D based on the month of the invoice, which the dates of the invoices are in column B. The sum is being displayed in column K.

The formula I am using (below) is summing all of the invoices, regardless of date.

Here is the formula I am using:

=SUM(IF(MONTH($B$2:$B$500)=10,$D$2:$D$500,0))