Oct 24 2022 01:21 AM
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.
Oct 24 2022 01:38 AM
That makes me suspect that the values in E3:E381 are not real numbers, but text values that look like numbers.
Try the following:
Does that make the formula work?
Oct 24 2022 02:21 AM
Oct 24 2022 02:25 AM
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.