| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting something like 430<x<=440
I tried =countif(B5:E29, "430<x<=440") but I always get 0, but I can clearly see that there are values that fit those criteria. Any ideas? -- infinite_zero00 ------------------------------------------------------------------------ infinite_zero00's Profile: http://www.excelforum.com/member.php...o&userid=28150 View this thread: http://www.excelforum.com/showthread...hreadid=476652 |
|
#2
|
|||
|
|||
|
Counting something like 430<x<=440
=countif(B5:E29, "430")-countif(b5:e59,"440") -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=476652 |
|
#3
|
|||
|
|||
|
Counting something like 430<x<=440
=SUMPRODUCT(--(B5:E29430),--(B5:E29<=440))
-- HTH RP (remove nothere from the email address if mailing direct) "infinite_zero00" <infinite_zero00.1x0jma_1129496705.0357@excelfor um-nospam.com wrote in message news:infinite_zero00.1x0jma_1129496705.0357@excelf orum-nospam.com... I tried =countif(B5:E29, "430<x<=440") but I always get 0, but I can clearly see that there are values that fit those criteria. Any ideas? -- infinite_zero00 ------------------------------------------------------------------------ infinite_zero00's Profile: http://www.excelforum.com/member.php...o&userid=28150 View this thread: http://www.excelforum.com/showthread...hreadid=476652 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting values and comparing them to a single cell | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
| Counting... | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
