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...
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?
So, by adding 'Round' in my formula in Column Q, that fixes my issue. Thank you for the insight!