Re: COUNTIF, dates and blank cell criteria

Giganews Newsgroups
Subject: Re: COUNTIF, dates and blank cell criteria
Posted by:  Bob Phillips (bob.N…@somewhere.com)
Date: Mon, 29 May 2006

=SUM(IF((TODAY()>A1:INDEX(A:A,MAX(IF(ISBLANK(G1:G65535),0,ROW(G1:G65535))))+
28)*
(G1:INDEX(G:G,MAX(IF(ISBLANK(G1:G65535),0,ROW(G1:G65535))))=""),1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"luvthavodka" <luvthavod…@discussions.microsoft.com> wrote in message
news:B8D96D87-169F-4DAD-ACFB-B13C6FC2AC…@microsoft.com...
> I'm looking to count the number of blank cells in column G (only upto the
> bottom of the data table I'm using - the length of which is unknown until
the
> end of the month, but only if the corresponding cell in column A (a date)
is
> greater than 28 days old. What formula should I use?

Replies

In response to

COUNTIF, dates and blank cell criteria posted by luvthavodka on Mon, 29 May 2006