Seaching a range

[Robo]

Hi,

I have a column on Sheet 2, say A1:A5, with a series of test results in it.
If any of the data is missing I've flagged that cell as "Results due"

My sheet 1 is a summary sheet. I want cell A1 to tell me if any of the
cells in the range have missing data, I'm not bothered about it which bit of
data is missing though.

Can anybody tell me which function might be best to use - I'm sure its
pretty simple.

Cheers,

 

[Per Jessen]

Hi

Try something like this:

=IF(COUNTIF(Sheet2!A1:A5,"Results due")>0,"Missing data","OK")

Regards,
Per