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 |
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 |
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 |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com