Results 1 to 17 of 17

Countif Decimal is within a range

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2018
    Location
    Prescott, WI
    MS-Off Ver
    365
    Posts
    36

    Question Countif Decimal is within a range

    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
    =COUNTIFS(E18:E200,".98",E18:E200, ".99",E18:E200,".00",E18:E200, ".01",E18:E200, ".02")
    Example
    5.00
    6.45
    7.86
    3.98
    2.99
    4.01
    12.02
    8.24

    Should = 5

    Any Assistance would be appreciated!
    Attached Files Attached Files
    Last edited by Bryan.Pagenkopf; 10-24-2018 at 01:18 PM. Reason: New Example File

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 02-24-2017, 02:06 AM
  2. [SOLVED] Sum of range picking up ^-10 decimal place. Is there a way to sum 2 decimal place only?
    By graym463 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2015, 08:48 AM
  3. SOLVED Countif formula with 4 decimal points
    By toclare84 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2015, 11:57 AM
  4. Replies: 2
    Last Post: 10-03-2012, 03:38 PM
  5. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  6. count decimal nos in a range
    By sheryar in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-12-2009, 05:39 AM
  7. COUNTIF or not to COUNTIF on a range in another sheet
    By Ellie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1