Count if question

[Guest]

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.

 

[Bob Phillips]

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

 

[Guest]

Brilliant worked perfectly, many thanks fro all your help.

Jody