# Get instant live expert help on countif multiple ranges

“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(AC710:BG710,"*am*")+COUNTIF(AC710:BG710,"*pm*")+COUNTIF(AC710:BG710,"*audit*")-COUNTIF(AC710:BG710,"*redo*")-COUNTIF(AC710:BG710,"*pre-training*") when I use this formula, Excel won't accept it but does not say there is an error in it. If I change the ranges to search from AD : BG, then it works. Any idea why?
Solved by G. H. in 14 mins
Using countif with multiple quantitative values.
Solved by F. Q. in 30 mins
Countif statement with multiple criteria!
Solved by C. U. in 22 mins
In Excel for Mac how do I build a pivot table from multiple ranges
Solved by S. C. in 25 mins
I have several ranges of numbers and need multiple formulas to generate the results for each range. The higher ranges also need to account for the amount generated in the lower ranges, thus making them cumulative.
Solved by X. Y. in 17 mins