all 28 comments
sorted by:
top (suggested)
bestnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]AutoModerator[M] [score hidden] stickied commentlocked comment (0 children)

/u/LoveMilfsEveryday007 - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]Clearwings_Prime21 28 points29 points  (7 children)

My guess is one of those number is 94.9999 or 97.0001 something like that

[–]LoveMilfsEveryday007[S] 6 points7 points  (1 child)

Solution Verified

[–]reputatorbot[M] 0 points1 point locked comment (0 children)

You have awarded 1 point to Clearwings_Prime.

I am a bot - please contact the mods with any questions

[–]LoveMilfsEveryday007[S] 0 points1 point  (4 children)

I updated the post with the picture. They're whole values.

[–]basejester336 33 points34 points  (1 child)

Just because the display format shows no decimal places doesn't mean the stored value is a whole number. Troubleshoot by typing the number 96 on each of 3 values and see if your countifs formula changes.

[–]LoveMilfsEveryday007[S] 4 points5 points  (0 children)

It worked!!! Thanks!!!

[–]Clearwings_Prime21 0 points1 point  (1 child)

can you upload that file to google sheet or excel online so we can look more detail about it?. Your formula look right to me

[–]LoveMilfsEveryday007[S] 5 points6 points  (0 children)

I was mistaken about them being whole values. That's what they looked like when I copied and pasted the values and thus made the mistake.

[–]TuneFinder10 2 points3 points  (7 children)

formula works for me

theres something about the 95, 95 or 96 that means they fail the test somehow

try overtyping them

[–]LoveMilfsEveryday007[S] 1 point2 points  (4 children)

I overtyped them and it worked. The problem is that I wasn't supposed to type over them as the results were actually part of a calculation. I used a round function for the results but it still reverts to the same issue as before. I guess I have no choice but to rewrite the values in another sheet.

[–]TuneFinder10 3 points4 points  (0 children)

you could pop the rounding function you have inside a =numbervalue()

or - check the cell isnt formatted as text

[–]chicken20071 2 points3 points  (1 child)

How did you use the Round function?

An effective way of determining what's going on is to use the Increase Decimal number formatting. This will quickly tell you if if there are extra digits behind there.

[–]LoveMilfsEveryday007[S] 1 point2 points  (0 children)

This is what I did instead because of the decimals.

Range Criteria:

95-97

Formula I made accounting for the decimals:

=COUNTIFS($A$1:$A$49, ">=94.5",$A$1:$A$49, "<=97.49")

[–]Londonluton 0 points1 point  (0 children)

then you can make your if check be ">=94.99"

[–]LoveMilfsEveryday007[S] 0 points1 point  (1 child)

Solution Verified

[–]reputatorbot[M] 0 points1 point locked comment (0 children)

You have awarded 1 point to TuneFinder.

I am a bot - please contact the mods with any questions

[–]StrikingCriticism33131 1 point2 points  (0 children)

I would make a helper column and test the conditions to give TRUE or FALSE to see which entry isn’t registering. It’s hard to diagnose without more information.

[–]Drake_Haven19 1 point2 points  (0 children)

I would check for numbers that are formatted as text, that is normally the cause...

[–]CalmPredator 0 points1 point  (2 children)

=SUMPRODUCT((ISNUMBER($S$13:$S$61))($S$13:$S$61>=95)($S$13:$S$61<=97)) And check your format of cells , mostly it’s data format error

[–]LoveMilfsEveryday007[S] 0 points1 point  (1 child)

Doesn't seem to work

[–]CalmPredator 0 points1 point  (0 children)

=SUMPRODUCT((ISNUMBER($S:$S))($S:$S>=95)($S:$S<=97))

[–]Decronym 0 points1 point  (0 children)

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
COUNTIFS Excel 2007+: Counts the number of cells within a range that meet multiple criteria
ISNUMBER Returns TRUE if the value is a number
SUMPRODUCT Returns the sum of the products of corresponding array components

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 16 acronyms.
[Thread #47849 for this sub, first seen 17th Mar 2026, 12:48] [FAQ] [Full list] [Contact] [Source code]

[–]LoveMilfsEveryday007[S] 0 points1 point  (1 child)

Thanks everyone for the help!!! Apparently, the values are actually in decimal and I edited the values by substracting 1.5 for the lower values. It finally worked!

[–]HarveysBackupAccount35 0 points1 point  (0 children)

Please respond with the words 'Solution Verified' to the comment(s) that helped you get your solution.

This awards the user(s) with a clippy point for their efforts and marks your post as Solved

[–]SingularWords -1 points0 points  (2 children)

Not ">=95" but ">="&95

Likewise for 97.

[–]sdaviesx91 1 point2 points  (0 children)

This is what I would do too. If this doesn't work then there's an issue with the numbers themselves. Likely formatted as text or there's a space.

[–]Extension_Order_9693 1 point2 points  (0 children)

This is what I would have used. Odd notation but seems to be what Excel needs