I did of course mean

=IF(COUNTIF(A1:J1,"0")7,"Yes","No")

Mike

"Mike H" wrote:

Maybe

=IF(COUNTIF(A1:J1,"7")7,"Yes","No")

Mike

"Windy" wrote:

I have 10 colums of dollar amounts and in column 11 I need a formula that
will tell me "if 7 of these columns are greater than 0, than yes, otherwise
no". I would appreciate any help. Thank you.