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.

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Archana" wrote in message
...
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.

Try this:

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

Biff

"Archana" wrote in message
...
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.