Ask Your Question

Please Help; COUNTIF(B1:B6,"x=>0")

asked 2017-04-15 13:16:58 +0100

abi gravatar image

updated 2017-12-10 17:04:50 +0100

erAck gravatar image

[what does "3 pts req'rd to dwnl'd files" Mean?]

edit retag flag offensive close merge delete


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

Lupp gravatar imageLupp ( 2017-04-15 13:37:28 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-04-15 13:31:56 +0100

Lupp gravatar image

updated 2017-04-15 13:33:03 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-15 13:16:58 +0100

Seen: 39 times

Last updated: Apr 15 '17