CODEWITHSUNDEEP
excelcountif
user2777137
user2777137

Reputation: 191

Excel: COUNTIF but the cells have "<" in the name

I want to use COUNTIF on a range of cells, and some of them look like "<1000" to indicate "less than 1000"

I want to count how many cells have "<1000" as text, but when I use COUNTIF it interprets the cell, I think, as if I were asking "how many cells in this range are less than 1000 lexicographically."

Upvotes: 1

Views: 257

Answers (1)

barry houdini
barry houdini

Reputation: 46341

Try this version assuming data in column A

=COUNTIF(A:A,"=<1000")

Upvotes: 4

Related Questions