I am trying to count data in one column based on dates in another,
Column A is either blank or non blanks and column B are Due dates.
I would like to have a count of all non blank cells that have a due
date before and including today. Preferably using the today()
function, as this is a constantly changing list, and I would prefer not
to type it in manually every day.
I've tried various ways of doing this, but excel seems to have a
problem with me using "*" to show the non blank cells.
Can anyone help me with this?


--
mcmillad
------------------------------------------------------------------------
mcmillad's Profile: http://www.excelforum.com/member.php...o&userid=33637
View this thread: http://www.excelforum.com/showthread...hreadid=534106

=SUMPRODUCT(--(A2:A200<""),--(B2:B200<=TODAY()))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mcmillad" wrote in
message ...

I am trying to count data in one column based on dates in another,
Column A is either blank or non blanks and column B are Due dates.
I would like to have a count of all non blank cells that have a due
date before and including today. Preferably using the today()
function, as this is a constantly changing list, and I would prefer not
to type it in manually every day.
I've tried various ways of doing this, but excel seems to have a
problem with me using "*" to show the non blank cells.
Can anyone help me with this?


--
mcmillad
------------------------------------------------------------------------
mcmillad's Profile:
http://www.excelforum.com/member.php...o&userid=33637
View this thread: http://www.excelforum.com/showthread...hreadid=534106