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.

=)

See the example he
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"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.

=)

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.

=)

Ooops!

You wanted <2.5, so:

=COUNTIF(B4:H28,"1.5")-COUNTIF(B4:H28,"2.4")

Biff

"Biff" wrote in message
...
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.

=)