Try:


=SUMPRODUCT(--(YEAR(B4:B4650)=2006),--(E4:E4650<"Rejected"),D4:D4650)

In article ,
Joe Gieder wrote:

First, thank you in advance for your help and looking at this.

I'm trying to use this formula to sum the values in cells D4:D4650 based on
the criteria that the date in cells B4:B4650 is from 2006 and it has not been
rejected (E4:E4650).
=SUMPRODUCT(--(B4:B4650=YEAR(2006)),--(E4:E4650<"Rejected"),(D4:D4650))

The problem with this formula is that it returns $0.00 and it should be over
$5m.

TIA for your help
Joe