Apply filter on both the colums. On end date column remove tick mark
from end date column Blanks on the status bar you can see the number
of cells being displayed. Else you can use =SUBTOTAL(3,A:A) in any of
the visible cells it would return the count.

A third option can be =COUNTA(A1:A100)-COUNTBLANK(B1:B100)

Hope that helps,
Anand

On Feb 9, 9:11*am, js20217075
wrote:
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.- Hide quoted text -

- Show quoted text -