Copper Contributor

Hi Guys, 

I'm trying to find how many times <10, 10-20, 20-40, 40-60, 60-80, and >80 occur in a column of data. I'm having trouble with the COUNTIF function and getting it to return the data I need correctly. 


When I use the following formula, =COUNTIF(E3:E381, "<10"), I get a return of 0, even though there are values less than 10 in the selected area. Any help would be appreciated with this. I'm so lost, I haven't even tried to do the formulas for the ranges of values yet.

3 Replies


That makes me suspect that the values in E3:E381 are not real numbers, but text values that look like numbers.

Try the following:

  • Select E3:E381.
  • Set the Number format to General or to Number.
  • On the Data tab of the ribbon, click Text to Columns.
  • Click Finish.

Does that make the formula work?

No luck with that. Is there another formula that would do what I'm hoping to accomplish?


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.