Hi,
Using Excel 2007. When I enter the following formula, I get the correct
answer.
=SUMPRODUCT(--((TODAY()-Eagan!$F$4:$F$200120)),--((TODAY()-Eagan!$F$4:$F$200<900)),--(Eagan!$I$4:$I$2000),--Eagan!$I$4:$I$200)

But, if I enter this formula as shown below, I get the incorrect answer.
=SUMPRODUCT(--((TODAY()-Eagan!$F$4:$F$200=121)),--(Eagan!$I$4:$I$2000),--Eagan!$I$4:$I$200).

Since I am at the end column for the aging, I no longer need to have an end
point (or this portion of the formula --((TODAY()-Eagan!$F$4:$F$200<900)).

I can't figure out what is wrong.

Can someone advise?

TIA