The formula below should include cells with a value of 0 like Excel does, but it ignores them:
=COUNTIFS(A1:A3,"<0.5",A1:A3,">-0.5")
And this formula does the opposite, it includes zeros this time when it should ignore…...Cells Product Family catnoise June 6, 2022, 2:06pm #1 The formula...one small error. Amjad_Sahi June 6, 2022, 3:00pm #2 @catnoise...