Hi,

I'm using Excel 2003. This formula works in all worksheets except for 2
(note name of worksheet in formula is changed for specific worksheet)

=SUMPRODUCT(--(Memphis!$F$4:$F$200<TODAY()),--(Memphis!$I$4:$I$200<0),--Memphis!$I$4:$I$200)

The 2 worksheets that this formula doesn't work on have the smallest range.
I want to use a consistent range in the formula and not have to change base
on the number of rows each worksheet may have.

Any advise on what could be wrong.

TIA