1. ## 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. ## Re: addition formula (EXCEL 2000)

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

=COUNTIF(H6:H36,"<=.10")-COUNTIF(H6:H36,"=0")

3. ## 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. ## 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. ## 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>

6. ## Re: addition formula (EXCEL 2000)

Still get formula to work...

7. ## Re: addition formula (EXCEL 2000)

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

8. ## 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