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: copy to clipboard
=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