I am trying to get a formula to count the number of outstanding letters by
member of staff.

I am trying to use the countif function with the isblank function (ie the
date of response isn't filled in).

=COUNTIF(Sheet1!$D$2:$D$20=$A4,&(ISBLANK(Sheet1!$F$2:$F$20)))

where sheet 1 col D = officer initials matched to col A

Is there an easy answer to my question? If you require further details
please ask.

Many thanks in advannce

Jody

and sheet1 col F will either be blank if no response has been made or
contain a date of response.

=SUMPRODUCT(--(Sheet1!$D$2:$D$20=$A4),--(ISBLANK(Sheet1!$F$2:$F$20)))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"traineeross" <(E-Mail Removed)> wrote in message
news:3407006A-1918-48BB-ACFC-(E-Mail Removed)...
>I am trying to get a formula to count the number of outstanding letters by
> member of staff.
>
> I am trying to use the countif function with the isblank function (ie the
> date of response isn't filled in).
>
> =COUNTIF(Sheet1!$D$2:$D$20=$A4,&(ISBLANK(Sheet1!$F$2:$F$20)))
>
> where sheet 1 col D = officer initials matched to col A
>
> Is there an easy answer to my question? If you require further details
> please ask.
>
> Many thanks in advannce
>
> Jody
>
> and sheet1 col F will either be blank if no response has been made or
> contain a date of response.
>
>

Brilliant worked perfectly, many thanks fro all your help.

Jody

"Bob Phillips" wrote:

> =SUMPRODUCT(--(Sheet1!$D$2:$D$20=$A4),--(ISBLANK(Sheet1!$F$2:$F$20)))
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "traineeross" <(E-Mail Removed)> wrote in message
> news:3407006A-1918-48BB-ACFC-(E-Mail Removed)...
> >I am trying to get a formula to count the number of outstanding letters by
> > member of staff.
> >
> > I am trying to use the countif function with the isblank function (ie the
> > date of response isn't filled in).
> >
> > =COUNTIF(Sheet1!$D$2:$D$20=$A4,&(ISBLANK(Sheet1!$F$2:$F$20)))
> >
> > where sheet 1 col D = officer initials matched to col A
> >
> > Is there an easy answer to my question? If you require further details
> > please ask.
> >
> > Many thanks in advannce
> >
> > Jody
> >
> > and sheet1 col F will either be blank if no response has been made or
> > contain a date of response.
> >
> >
>
>
>