count values greater 2 or greater in a column. I tried this but it didn't work. =COUNTIF(C5:C23,=>2)
Thanks
count values greater 2 or greater in a column. I tried this but it didn't work. =COUNTIF(C5:C23,=>2)
Thanks
Try this
=COUNTIF(A1:A10,">2")
A B 1 2 6 2 81 3 1 4 2 5 5 6 0 7 10 8 70 9 3 10 99
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Isn't that for greater than 2? I want values for = or greater than 2. When I put your formula in (greater than 2) it counts correctly but when I put "=>2" it doesn't.
Then this
=COUNTIF(A1:A10,">=2")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks