Hi!
Try this:
=COUNTIF(B4:H28,"1.5")-COUNTIF(B4:H28,"2.5")
Biff
"Daesthai" wrote in message
...
I'm a bit confused combining these two functions.
What would I use if I wanted to count the cells in a table that are
greater
than 1.5 but lower than 2.5?
=countif(B4:H28,AND("1.5","<2.5")) gives me back an incorrect count, so
I'm doing something wrong.
=)
|