Excel 2007 : Sumif by month help

[nixboy]

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

[NBVC]

Did you confirm that formula with CTRL+SHIFT+ENTER not just ENTER as it is an array formula...

or you can try:


=SUMPRODUCT(--(MONTH($B$2:$B$500)=10),$D$2:$D$500)