Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Check for Values

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Gotta row of values and want to summarize the number of values that fall within certain ranges (ie. <5; equal to 5 but less than 10; equal to 10 but less than 15; and 15 of greater. Would like to reflect the count for each range in a seperate cell. Can anyone help me out?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    California
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =SUM((E45:E56>=5)*(E45:E56<=8)*(F45:F56))

    Try this and enter it as an array control/shift/Enter

    Whatever your range is adjust and assuming you have values next to criteria
    numbers in column E and values you want summed in column F


  3. #3
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I have the data in from A1 to AX1, then entyer the folowing formula in cells A2, B2, C2, and D2, I get the results you want
    A2 =COUNTIF(A1:AX1,"<5")
    B2 =COUNTIF(A1:AX1,"<10")-A2
    C2 =COUNTIF(A1:AX1,"<15")-SUM(A2:B2)
    D2 =COUNTIF(A1:AX1,">14")

    Is this what you're after?
    Richard

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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