Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    May 2004
    Location
    Under a Bridge, Massachusetts, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    addition formula (EXCEL 2000)

    Within a range of cells Im trying to record >0.0 <=.10 This formula works =COUNTIF(H6:H36,"<=.10")except it counts all the zero entrees also which I don't want, just greater than 0 but equal to or less than .10. Appreciate any help thanks.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: addition formula (EXCEL 2000)

    Just subtract the number of zeroes (and emopty cells) then:

    =COUNTIF(H6:H36,"<=.10")-COUNTIF(H6:H36,"=0")
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: addition formula (EXCEL 2000)

    You can use

    <code>=COUNTIF(H6:H36,"<=.1")-COUNTIF(H6:H36,"<=0")</code>

    Note: sometimes, the browser messes up "less than or equal", if you see something with lt in it, both conditions should contain "less than" < followed by "equal" = without a space in between.

  4. #4
    New Lounger
    Join Date
    May 2004
    Location
    Under a Bridge, Massachusetts, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: addition formula (EXCEL 2000)

    Attached sheet I38 is where I would like to keep track of liquid precipitation in the range(H6:H36) from 0.01 - 0.10 only.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: addition formula (EXCEL 2000)

    For the number of values in the range 0.01 - 0.10 (limits included), use

    <code>=COUNTIF(H6:H36,"<=0.10")-COUNTIF(H6:H36,"<0.01")</code>

    For other limits, adjust accordingly.

  6. #6
    New Lounger
    Join Date
    May 2004
    Location
    Under a Bridge, Massachusetts, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: addition formula (EXCEL 2000)

    Still get formula to work...

  7. #7
    New Lounger
    Join Date
    May 2004
    Location
    Under a Bridge, Massachusetts, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: addition formula (EXCEL 2000)

    Last message should say 'still can't get formula to work "

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: addition formula (EXCEL 2000)

    Look at the formula in your cell and the formula here
    It should be:
    =COUNTIF(H6:H36,"<=0.10")-COUNTIF(H6:H36,"<0.01")

    Hans warned that the formatted text could copy funny.
    Also remove the TEXT format (format - cells - Number - 0 decimals is more appropriate)

    Steve

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: addition formula (EXCEL 2000)

    In addition to Steve

  10. #10
    New Lounger
    Join Date
    May 2004
    Location
    Under a Bridge, Massachusetts, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: addition formula (EXCEL 2000)

    Finally got it! Thank You.

Posting Permissions

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