Please Help; COUNTIF(B1:B6,"x=>0")
[what does "3 pts req'rd to dwnl'd files" Mean?]
First time here? Check out the FAQ!
[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
How to: a live template sheet that is used by multiple sheets
Pivot table and (empty) results on fields
Modify named range in Calc [closed]
Calc: formula: why are tildes auto-replacing commas?
Invoice number and auto increment [closed]
Calc: how to export to xml [closed]
How to convert column in $ to other column in euro?
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 ...