In numbers for iPad I’m trying to use the COUNTIF function to count the number of times values in a given array are greater than zero.
I’m using
=(countif(k2:k32),>0)
but I keep getting a syntax error. I’m hoping someone can help.
J
iPad Pro, iPadOS 16
Place " " around the >0.
=COUNTIF(K2:K32,">0")
SG
Place " " around the >0.
=COUNTIF(K2:K32,">0")
SG
Jmcdon wrote:
I wish there was some kind of hint in the program.
If you haven't already be sure to check out the many examples at Help > Formulas and Functions Help in your menu. You can search there for the function you want. Here's the one for COUNTIF
You'll see in the examples there the use of " ".
Thanks for the green tick!
SG
In addition to SG's referral to Help > Formula, you can quickly obtain a function's description and expected parameters by showing the Format sidebar and typing = in a cell. Usually these are all the hints you need.
Thank you! Golly but I wish there was some kind of hint in the program. I didn’t have a clue!
Thank you.
Numbers, countif
