formulas

[Windy]

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.

 

[Mike H]

Maybe

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

Mike

 

[Sandy Mann]

I think that you meant:

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

didn't you Mike? That is assuming hat the OP Mean
"if 7 or more of these columns are greater than 0"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

I did of course mean

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

Mike

 

[Mike H]

I did mean that, well spotted

I think that you meant:

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

didn't you Mike? That is assuming hat the OP Mean
"if 7 or more of these columns are greater than 0"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk