IF function used in a range / Countif

[Besh]

Hi there,

Right now I'm sort of cheating and I would like to clean this up for future users/editors.

Currently, cell E2 is:
=IF(G55=26,"Evaluation Complete","Evaluation Incomplete")

While the G55 cell it's referencing is:
=COUNTIF(E5:G53,"x")

Ideally, I would like cell E2 to do everything by itself so to speak...

I want E2 to count the amount of "x" within the range E:G53. If it's = to 26, I want the cell to display ,"Evaluation Complete" and if it's < 26 I want it to display "Evaluation Incomplete".

How shall I go about doing this?

Thanks! Besh

 

[anglais428]

=IF(COUNTIF(E5:G53,"X")=26,"Evaluation complete","Evaluation incomplete")

 

[Besh]

to add, it doesn't actually matter if it's < 26. false / true is enough i.e. if true = complete, if false = incomplete

 

[Besh]

thanks for the reply, can u tell me why it would be displaying "0" in the cell as opposed to "Evaluation complete" or "Evaluation incomplete"? I copied and pasted exactly.

 

[Besh]

i deleted the cell and completely replaced it with a new one and it worked, thanks for your help!

besh