Forum Discussion
Countif not working- input data is less than 10
I have a spreadsheet with multiple formulas to give me an output value. I then want to total up how many of each value there are. Countif will not count the value if the first input data is less than 10. You can see from my example screenshot that excel does not even recognize the value as being significant. There are two lines of data and formulas, the only difference between the two is the first input number changed from 12 to 8. There are multiple lines on my actual working spreadsheet with this anomaly. I have reformatted the whole spreadsheet to General and Number, with no success. Any ideas what is going on?
Thank you in advance!
Select column Q.
Set the number format to Number with 15 decimal places.
Adjust the column width so that the entire number is displayed.
What do you see?
Any Hidden Characters?
- keandauCopper Contributor
No hidden characters. It is a new spreadsheet I began today. Just typed my first line with the needed formulas and dragged the formulas down through the subsequent rows.