I have a column of numbers ranging from 0000-9999. They are not in order and multiple numbers are used more than once. I would like to know how many times the numbers in the range of 4000-4999 appear. I am trying to use the formula =COUNTIF(F4:F500,"=4????") or =COUNTIF(F4:F500,"=4*") but neither are working. If I do a single number like this =COUNTIF(F4:F500,"=41420"), it will count them for me. HELP!!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Countif Formula not working, why?
- Thread starter lansawc
- Start date
Excel Facts
What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Re: count if
If
=COUNTA(D3:D4)
yields a non-zero result, that would mean that the range in question houses something...
Does this help?
If
=COUNTA(D3:D4)
yields a non-zero result, that would mean that the range in question houses something...
Does this help?
Upvote
0
Similar threads
