If count
in [Functions]
|
From: js20217075 on 8 Feb 2010 21:31 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: js20217075 on 8 Feb 2010 21:34 Please help! I only have 1/2 an hour to figure this out. "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: Fred Smith on 8 Feb 2010 22:32 The clearer the question, the faster the response, and vice versa. Things that help are the version of Excel you are using, and where the data is (column A, B, etc.). For this, I've assumed your start date is in A, and your end date is in B. For all entries in A, where there is no entry in B: =sumproduct(--(a1:a1000<>""),--(b1: b1000="")) Adjust the range to suit. For specific entries in A, with no entry in B: =sumproduct(--(a1:a1000=date(2010,1,1)),--(b1:b1000="")) Regards, Fred "js20217075" <js20217075(a)discussions.microsoft.com> wrote in message news:38D25C25-E95D-4727-8ED5-1C5E4A2C4308(a)microsoft.com... > Please help! I only have 1/2 an hour to figure this out. > > "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: Jacob Skaria on 8 Feb 2010 22:59 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: js20217075 on 8 Feb 2010 23:11
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. |