addition formula (EXCEL 2000)

Topic

New Reply

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.

Reply | Quote

Replies

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

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

Reply | Quote

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

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

Reply | Quote

You can use

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

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.

Reply | Quote

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.

Reply | Quote

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

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

For other limits, adjust accordingly.

Reply | Quote

Still get formula to work…

Reply | Quote

Last message should say ‘still can’t get formula to work “

Reply | Quote

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

Reply | Quote

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

Reply | Quote

In addition to Steve

Reply | Quote

Finally got it! Thank You.

Reply | Quote

Finally got it! Thank You.

Reply | Quote

In addition to Steve

Reply | Quote

Last message should say ‘still can’t get formula to work “

Reply | Quote

Still get formula to work…

Reply | Quote

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

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

For other limits, adjust accordingly.

Reply | Quote

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.

Reply | Quote

You can use

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

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.

Reply | Quote