I'm trying to construct a COUNTIF formula which counts the number of 3s (rounded) in a given range. The problem is, these numbers are decimal and therefore are not being read. Even when I use the ROUND function I cannot get it to count them.
This is the formula I'm currently using:
Formula:
=COUNTIF(A1:F1,3)
And this is the range of data I am counting.
3.00000032436
0.00000032436
3.00000091496
3.00000032436
3.00000038436
0.00000024269
Bookmarks