If all cells = "OK" then.....

[Ctech]

I have a 10 cells containing the word "OK" or "Error" depending on an IF statement in each cell.

However Im now trying my make a sum cell for this. IF all cells contains OK then "OK" if not write "Error"..

How can I do this?

[Bob Phillips]

=IF(COUNTIF(A1:M1,"OK")=13,"OK","Error")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ctech" <[email protected]> wrote in
message news:[email protected]...
>
> I have a 10 cells containing the word "OK" or "Error" depending on an IF
> statement in each cell.
>
> However Im now trying my make a sum cell for this. IF all cells
> contains OK then "OK" if not write "Error"..
>
> How can I do this?
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=516538
>

[Ctech]

Thanks

Regards,

Chris

[davesexcel]

[QUOTE=Ctech]I have a 10 cells containing the word "OK" or "Error" depending on an IF statement in each cell.

However Im now trying my make a sum cell for this. IF all cells contains OK then "OK" if not write "Error"..


=COUNTIF(A1:A10,"ok")
=if(range=10,then"ok","error")