If count
in [Functions]
|
From: Jacob Skaria on 8 Feb 2010 23:15 Try one of these.. =SUMPRODUCT((A1:A100>0)*(B1:B100=0)) =SUMPRODUCT((ISNUMBER(A1:A100))*(ISBLANK(B1:B100))) -- Jacob "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.
From: Anand on 9 Feb 2010 04:08
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 <js20217...(a)discussions.microsoft.com> 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 - |