Help!
I am trying to count all the occurrances of a multiple condition worksheet, with the data arranged as:
A1 : W or L
A2 : X%
B1 : W or L
B2 : X%
... up to 100 or some rows.
I want to count all the occurrances of a "W" with a certain percentage, say ">50%". I want all "L"s to be ignored.
The problem is that the % is entered as a calculation from the formula below:
A2 = IF(ISNUMBER(X1),X1/some total number,""),
so that it returns an empty cell instead of "0%" when there is no number in X1.
I can't figure out how to do a bi-conditional comparison to count all occurrances of a "W" and ">50%" because of the formula. I tried the suggestions below but have not been successful yet.
This message was edited by Kevuas on 2002-04-28 17:04
I am trying to count all the occurrances of a multiple condition worksheet, with the data arranged as:
A1 : W or L
A2 : X%
B1 : W or L
B2 : X%
... up to 100 or some rows.
I want to count all the occurrances of a "W" with a certain percentage, say ">50%". I want all "L"s to be ignored.
The problem is that the % is entered as a calculation from the formula below:
A2 = IF(ISNUMBER(X1),X1/some total number,""),
so that it returns an empty cell instead of "0%" when there is no number in X1.
I can't figure out how to do a bi-conditional comparison to count all occurrances of a "W" and ">50%" because of the formula. I tried the suggestions below but have not been successful yet.
This message was edited by Kevuas on 2002-04-28 17:04