This isn't working. OMG do you know anything else to try?

"Jacob Skaria" wrote:

Try
=SUMPRODUCT((A1:A100<"")*(B1:B100=""))

--
Jacob


"js20217075" wrote:

start date end date
01/01/2010 01/01/2010
01/01/2010
01/01/2010
01/01/2010 01/01/2011
01/01/2010
01/01/2010
I want to count the start date column only if there is nothing in the end
date column.