formulas

W

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.
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

Mike H

I did mean that, well spotted :)

Sandy Mann said:
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Top