Get instant live Excel expert help to figure out how to COUNTIF between two cell values

“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

using the countif function between two dates, worked before but when expanding the data set does not work anymore gives #value error
Solved by C. D. in 30 mins
I need a formula to tell me how many cells in a column are between two numbers (e.g. 70 to 71). Have tried countif, but am likely doing it wrong. Thanks
Solved by S. Y. in 21 mins
Hi I want to do a countif between two cell references. See highlight on attached. I have the Range Bottom entered but I want to add Range Top. So in C16 i want to count if >c3 and <G3. I can do the first greater than count but can't work out how to add the less than.
Solved by T. Y. in 19 mins