I am using TI-nspire spreadsheets
I want to find the number of values that are greater than 5 and less than 10
the numbers are stored in a column called "data" and also in cells A1 to A5
the numbers are {7,4,25,39,9} we can recall it in any formula using the word data or A1:A5 or even {7,4,25,39,9}
I know the answer is 2 but this is a simplified example so I can find the correct formula to solve harder ones
(https://i.sstatic.net/7DUXlceK.png)
I tried all of these commands that keep showing either 0 or syntax errors even if I add or remove quotation marks or add this symbol "≥" is it that I am using this function wrong or is there another function that does what I need? (https://i.sstatic.net/e8f3J2Nv.png)(https://i.sstatic.net/26pQpQZM.png)
countIf(A1:A5, ">5") - countIf(A1:A5, ">=10")
outputs: 0
countIf(A1:A5, >5) - countIf(A1:A5, >=10)
outputs: syntax error
countIf({7,4,25,39,9}, ">5") - countIf({7,4,25,39,9}, ">=10")
outputs: 0
countIf({7,4,25,39,9}, >5) - countIf({7,4,25,39,9}, >=10)
outputs: syntax error
countIf(data, ">5") - countIf(data, ">=10")
outputs: 0
countIf(data, >5) - countIf(data, >=10)
outputs: syntax error
count(A1:A5, ">5") - count(A1:A5, ">=10")
outputs: 0
count(A1:A5, >5) - count(A1:A5, >=10)
outputs: syntax error
count({7,4,25,39,9}, ">5") - count({7,4,25,39,9}, ">=10")
outputs: 0
count({7,4,25,39,9}, >5) - count({7,4,25,39,9}, >=10)
outputs: syntax error
count(data, ">5") - count(data, ">=10")
outputs: 0
count(data, >5) - count(data, >=10)
outputs: syntax error
countif(a1:a5,">5")-countif(a1:a5,"≥10")
outputs: 0
countif(a1:a5,>5)-countif(a1:a5,≥10)
outputs: syntax error
As as I remember, the syntax for countIf
requires you to put a question mark where the value is to be inserted.
Write countIf(a, ?>5)
when working with the values in column A.
UPDATE