+ Reply to Thread
Results 1 to 3 of 3

Formula for counting how many inputs between 0-9999 in a given range?

  1. 10-08-2020, 09:01 PM #1
    connor2282
    connor2282 is offline
    Registered User
    Join Date
    10-06-2020
    Location
    Georgia, USA
    MS-Off Ver
    365
    Posts
    13

    Smile Formula for counting how many inputs between 0-9999 in a given range?

    Hi what formula do i use to count if a number is between 0-9999 in a given range?
    I can attach a file if need be, thanks!
    Last edited by connor2282; 10-08-2020 at 09:19 PM.
    Reply With QuoteRegister To Reply
  2. 10-08-2020, 09:09 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Formula for counting how many inputs between 0-9999 in a given range?

    The COUNTIFS() function, maybe? https://support.microsoft.com/en-us/...rs=en-us&ad=us Something like =COUNTIFS(range,range,">=0",range,"<=9999")
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 10-08-2020, 09:18 PM #3
    connor2282
    connor2282 is offline
    Registered User
    Join Date
    10-06-2020
    Location
    Georgia, USA
    MS-Off Ver
    365
    Posts
    13

    Re: Formula for counting how many inputs between 0-9999 in a given range?

    okay that makes sense, just use the same range twice!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] please, chosen 4 digits * decrease by 9999 and add by * 9999.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2019, 12:18 PM
  2. Help With Counting Cell Inputs and Macros :)
    By ASHayward in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2017, 07:47 AM
  3. Generate 10,000 16 digit string starting from 9000 0000 0000 000 -9999 9999 9999 9999
    By flamez11 in forum Excel General
    Replies: 8
    Last Post: 05-15-2017, 05:54 AM
  4. [SOLVED] Add If zero than 9999 to my formula
    By mattress58 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2014, 12:46 PM
  5. How to calculate more than 9999:00:00 hours?
    By dask in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2009, 05:23 AM
  6. add time greater than 9999:56
    By PapaT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2006, 10:55 PM
  7. Find value (31.12.9999) and clear
    By Tempy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2005, 09:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1