+ Reply to Thread
Results 1 to 2 of 2

If statement for finding where numbers in a column fall in multiple ranges

  1. #1
    Registered User
    Join Date
    04-10-2008
    Posts
    1

    If statement for finding where numbers in a column fall in multiple ranges

    I have an extremely long column of numbers and i want to determine where those numbers each fall into various ranges. they are a list of times in seconds. i want to know how many fall less than 30 seconds, between 30 seconds and 1 minute, 1 to 2 minutes, 2-3 minutes, and so on. I figure that i can create a nested IF statement in series that will help spit out results into a second column to the right giving a flag as to which range each number falls into. later I'll be able to run a pivot table and tell how many fall into the given ranges taht i specify. I can't seem to get the formula right. is there a better way?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    I think with Excel 2002 and up, there's a function called COUNTIFS which you should look into. I am using Excel2000 so I resorted to SumProduct. I used normal numbers (e.g. 0.5 = 30 seconds, 1.5 = 1 minute 30 seconds). For the first criteria
    Please Login or Register  to view this content.
    The "--" changes True/False to 1/0.
    the second criteria (others are similar)
    Please Login or Register  to view this content.
    Any questions?

    ChemistB
    Attached Files Attached Files
    Last edited by ChemistB; 04-10-2008 at 11:50 AM. Reason: Added File

+ 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