 # Get instant live expert help on how to do countif in excel “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 ISSUES, HOW DO I PUT IN THE RANGE WITHOUT IT SAYING ERROR
Solved by O. D. in 11 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
I'm trying to do a countif which totals the number of times an if() came back true. as well as false in a seperate function. my most basic question is: how do you do a countif() on a range of cells which contain a function?
Solved by V. U. in 23 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
Hello How do I convert the formula below from a true value to an actual number? Thanks for your help! =(COUNTIF(\$C\$4:\$C\$8,G4)*3)>(COUNTIF(\$C\$4:\$C\$8,G5)*2)>(COUNTIF(\$C\$4:\$C\$8,G6)*1)>(COUNTIF(\$C\$4:\$C\$8,G7)*0)
Solved by F. A. in 26 mins