Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm wanting to count the number of cells that have a value between 10 and
12.1. The current range (before I add any more is F2:F19. Can anyone see what's wrong with this formula. I'm stumped and it's probably sooooo simple. Fortunately, the sample is small enough to see that the results are wrong. Correct result is 3, however, it generates a result of 11. Can someone help. Please and thanks. =COUNTIF(F2:F19,"<12.1")-COUNTIF(F2:F19,"10") The data in the range is: 9 3 3 5 15 10 1 8 7 8 11 12 10 0 2 12 1 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Countif ??? | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |