=SUMPRODUCT(--(E3:E129<=NOW()),--(E3:E129<""))

"Mark Hanson" wrote:

Hello All,

I was wondering if you could help me, I am using the following formula in
Excel 2003.

=SUMPRODUCT(--(E3:E129<=(NOW())))

This is basically telling me any values that are before the current date
(i.e Expired training). The formula works OK but is counting blank cells
(Not everyone has done the training!!).

Can anyone let me know how to amend this formula to exclude blank cells.

Many Thanks

Mark