Hello,
I have a list of almost 200 numbers, all of them to the nearest hundredth point.
What I am trying to accomplish is to do a CountIf(Decimal points is between .98 and .02) regardless of what the whole number is.
I keep getting and answer of 0
Example![]()
=COUNTIFS(E18:E200,".98",E18:E200, ".99",E18:E200,".00",E18:E200, ".01",E18:E200, ".02")
5.00
6.45
7.86
3.98
2.99
4.01
12.02
8.24
Should = 5
Any Assistance would be appreciated!
Bookmarks