Long Logical function

[Guest]

I have a tracking sheet where I want to enter a formula to enter in cell
"done" if a range of cells from A3:A54 all have a value "done" or "NA" else
keep blank.
How do I do it?
The formula is turning out t be too long and cannot be entered.

 

[Arvi Laanemets]

Hi

=IF((COUNTIF($A$3:$A$54;"done")+COUNTIF($A$3:$A$54;"NA"))=52;"done";"")

 

[T. Valko]

Try this:

=IF(SUM(COUNTIF(A3:A54,{"done","na"}))=52,"done","")

Biff