“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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