Thanks Harlan for drawing to my attention that I had not fully tested my
formulas, and left a couple of holes in them. I answered too quickly
without studying the whole criteria(s). I respectfully apologize to the OP
for that. After re-reading both of the OP's posts in this thread and doing
additional testing, I now submit the following.........

=IF(COUNTA(BN23:BQ23,BX23)COUNT(BN23:BQ23,BX23)," ",IF((COUNT(BN23:BQ23)+COU
NT(BX23))=5,BX23-BQ23-BP23-BO23-BN23,""))

of, if the cells of interest were collected into a Non-contiguious RangeName
"OPrange"........

=IF(COUNTA(OPrange)COUNT(OPrange),"",IF(COUNT(OPr ange)=5,BX23-BQ23-BP23-BO2
3-BN23,""))

Vaya con Dios,
Chuck, CABGx3



"Harlan Grove" wrote in message
...
"CLR" wrote...
Well then..........maybe this.......


=IF(OR(ISTEXT(BN23),ISTEXT(BO23),ISTEXT(BP23),IST EXT(BQ23),ISTEXT(BX23)),""
,
PutYourFormulaHere)

This works.

or this

=IF(COUNTA(BN23:BQ23,BX23)COUNT(BN23:BQ23,BX23), "",PutYourFormulaHere)
...

This may not work if the OP wants to exclude cells containing boolean or
error values, which aren't text but would be counted by COUNTA. For that
matter, it fails when all cells are blank.

Try

=IF(COUNTIF(BN23:BQ23,"*")+ISTEXT(BX23)=5,PutYourF ormulaHere,"")