countif problem
Posted by Larry on July 10, 2001 7:38 PM
I am trying to countif a range of cells that are not congruent and am having trouble with it. For example, I want to find out how many cells from the range d5:d7, d11:d12, and d16:d20 are less than 50%. I named the range "percentachieved" and put the formula as thus "countif(percentachieved>50%)" and it's giving me an error value. Can anyone tell me what I'm doing wrong and how I can fix it? By the way, the above mentioned cells are set as percentage and they have formulas in them to get the resulting percentage. Any help anyone could give me would be immensely appreciated.
Posted by Aladin Akyurek on July 10, 2001 8:58 PM
=COUNTIF(D5:D7,"<50%")+COUNTIF(D11:D12,"<50%")+COUNTIF(D16:D20,"<50%")
Aladin
Posted by Larry on July 11, 2001 5:11 AM
Thanks a million!
