It might be the NG wrap-around. Try this version

=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))

still array entered

--
HTH

Bob Phillips

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

"luvthavodka" <luvthavodka@discussions.microsoft.com> wrote in message
news:94C950A3-1209-4FF8-B23A-F2253212B091@microsoft.com...
> Thanks Bob, but i'm getting a #VALUE return with this. Have committed with
> Ctrl-Shift-Enter...is there anything else I could have done wrong?
>
> Regards
>
> Jenny
>
> "Bob Phillips" wrote:
>
> >
=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" <luvthavodka@discussions.microsoft.com> wrote in message
> > news:B8D96D87-169F-4DAD-ACFB-B13C6FC2AC3C@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?
> >
> >
> >