Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. =) |
#2
|
|||
|
|||
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. =) |
#3
|
|||
|
|||
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. =) |
#4
|
|||
|
|||
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. =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|