View Single Post
  #1   Report Post  
Daesthai
 
Posts: n/a
Default combining countif with AND function

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.

=)