Thank You! I wrestled with this for 2 days. Nestled functions are kinda
tough. Nice clean solution...thanks again.

"Martin P" wrote:

This might help:
=IF(AND(SUMPRODUCT(--(A2:A6="f"))0,ISBLANK(A1)=TRUE),1,0)

"Shinka" wrote:

Trying to get a cell to show a 1 (so I can add it), IF cell A1 is blank and
A2 thru A6 has an "f" in any of them.

If/AND formulas are killing me! Your help is appreaciated.