 # Get instant live expert help on countif date range “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Countif A collumn of dates is less than a date in a specific date. =COUNTIF(D3:D438,"<E575") Did not work.
Solved by T. B. in 25 mins
I am using a countif formula =COUNTIF(T3:T873,W3), however I need to drag it down so I get =COUNTIF(T3:T873,W4) , =COUNTIF(T3:T873,W5) ect. However, when I do this the range changes as well so its goes to =COUNTIF(T4:T874,W4) =COUNTIF(T5:T875,W3) and so on. How do I keep the range constant and only change the criteria?
Solved by X. F. in 13 mins
COUNTIF ISSUES, HOW DO I PUT IN THE RANGE WITHOUT IT SAYING ERROR
Solved by O. D. in 11 mins
I need help building a countif formula, the formula needs to count how many inputs within a certain range =<3 (e.g. =COUNTIF(C75:BJ75,"<3")) and also needs to add 2 to this value every time there is the number 12 present in this range
Solved by S. A. in 20 mins
I am using COUNTIF, but I want to use three unconnected cells as my range. How do i do that?
Solved by B. U. in 29 mins