# Get instant live Excel expert help with a COUNTIF Functions

“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

I want to use the COUNTIF function for a cell that contains more than 1 number for example i want to count how many number 1's there are in a selected data set, but some of my cells contain more than two numbers such as "1,4" if it is like this the countif function does not count it as containing the number 1, is there any way around this
Solved by A. J. in 22 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
when running a countif search from one spreadsheet to another to determine how many times a number duplicates. How when copy and pasting the formula do you get the selected cell to change with the copy and paste.
Solved by A. D. in 18 mins
Having unexpected behavior with CountIf statements. It counts the occurrence of a string passed into a function, However, when a number with the less than operator i.e. <5 is passed in, does not behave well.
Solved by A. F. in 21 mins
I am trying to use a COUNTIF formula, and I know for a fact (have triple checked) that I'm using the correct characters. Excel INSISTS that the formula is not correct...
Solved by C. J. in 24 mins
hi, i'm trying to write a countif formula ... pls can i have a little help? thanks
Solved by E. S. in 13 mins
I have a large excel document with many sheets (1 sheet per day) and I need to have a monthly total sheet as well. I am having trouble getting the countifs or countif formulas to work.
Solved by X. U. in 29 mins
My formula contains an error that I can not resolve. I am trying to use the countif function to determine certain criteria without any success
Solved by V. E. in 23 mins
I need to count and sum the cells with any value in them. These same cells already contain a formula. How do i get my countif function to ignore the formula and count only those cells that contain a value?
Solved by K. H. in 21 mins
Go to cell M50, and then insert a COUNTIF function to count the number of unassigned (Staff) judges. In cell K50, type Events with Unassigned Judges.
Solved by I. L. in 13 mins