LinkBack URL
About LinkBacks
On one collumn I have <19 listed and the countif function won't count it
I have:
=COUNTIF(C2:C100,"<19")
Is there any reason why this isn't working? Or any way that I can make it work?
On one collumn I have <19 listed and the countif function won't count it
I have:
=COUNTIF(C2:C100,"<19")
Is there any reason why this isn't working? Or any way that I can make it work?
Never saw that error before, but I found a solution.
=COUNTIF(C2:C100,"*<19")
Do you want it count values less than 19 or cells explicitly containing "<19" ?
Elegant Simplicity............. Not Always
It's because the COUNTIF function evaluates the entry <19 as meaning literally "less than 19".
Try this experiment.
Enter some random numbers in the range A1:A20.
Enter <19 in cell C1.
Then, enter this formula in cell D1:
=COUNTIF(A1:A20,C1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If you want to count the instances of the text string <19 then you can use daffodil11's suggestion or this one:
=SUMPRODUCT(--(A1:A20="<19"))
Perfect! Daffodil11 that worked and was exactly what I needed! Awesome!
Thanks everyone for answering!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks