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

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

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ctech" wrote in
message ...

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

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

Thanks

Regards,

Chris


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=516538

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

Ctech Wrote:
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"..

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516538