+ Reply to Thread
Results 1 to 2 of 2

how to find if a number falls between 2 values(not solved but can't change)

Hybrid View

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    how to find if a number falls between 2 values(not solved but can't change)

    In my darts statistics sheet I have columns that keep track of all sores between 0-19, 20-3, 40-59 and so on. On my mac I used count if to check if it fell between the 2 particular values but when I open in docs to go or office suite on my tablet it says the function is not supported. Can I do it with a different function so it will work non mobile and tablet?
    Thanks
    Excel novice:o
    Last edited by unibiggle; 02-04-2013 at 01:07 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: how to find if a number falls between 2 values(not solved but can't change)

    Is it COUNTIFS you are using? Perhaps try 2* COUNTIF, e.g. for 40-59 inclusive

    =COUNTIF(range,">=40")-COUNTIF(range,">59")
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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