Please Help; COUNTIF(B1:B6,"x=>0")
[what does "3 pts req'rd to dwnl'd files" Mean?]
As I cannot think of another supposed meaning of x than "the respective value found in the range" I suppose
=COUNTIF(B1:B6;">=0") should be the formula you are looking for. The role you tried to use x in, is implicit if I guessed right.
The 'criterion concept' has its flaws, however. =SUMPRODUCT(IF(B1:B6>=0;1;0)) will do it, too, and is more flexible. Since a comparison anyway returns a 1 if it came out true and a 0 (zero) otherwise,
=SUMPRODUCT(B1:B6>=0) is sufficient.
Asked: 2017-04-15 13:16:58 +0100
Seen: 39 times
Last updated: Apr 15 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
To answer this question will require some guessing again.
To perform specific actions you will need a minimum amounts on your "karma" account. The respective amount depends on the action you want to choose.
Karma >= 3 may be the amount needed for uploading a file.
Additional karma is assigned if other users upvote a well worded or specifically interesting question e.g. Another case occurs if a questioner accepts an answer ...