formulas
 

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.

formulas
 

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.

formulas
 

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


Replace @mailinator.com with @tiscali.co.uk


"Mike H" wrote in message
...
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.

formulas
 

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.

formulas
 

I did mean that, well spotted :)

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Mike H" wrote in message
...
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.