Formula help

[Katy Jordan]

Why is the formula in C2 returning Ok when there are 2 cells with "ERROR"?

Excel Workbook
	A	B	C
1	Check
2	OK		OK
3	OK
4	OK
5	OK
6	OK
7	OK
8	OK
9	OK
10	OK
11	OK
12	OK
13	OK
14	OK
15	OK
16	OK
17	ERROR
18	OK
19	OK
20	ERROR
Sheet1

 

[crook_101]

Hi,

Try:

=IF(COUNTIF(A2:A20,"ERROR")>0,"ERROR","OK")

if you are looking for any "Error" in the range to generate the error in C2

Regards,
Ian