| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count function
How do I count the number of times a number is between two numbers?
range of cells is B5:B33 would like to know how many times a number shows up that is 124 but <150 |
|
#2
|
|||
|
|||
|
Try either:
=SUMPRODUCT((B5:B33124)*(B5:B33<150)) or: =COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150) -- Rgds Max xl 97 --- Please respond in thread xdemechanik <atyahoo<dotcom ---- "ChrisC" wrote in message ... How do I count the number of times a number is between two numbers? range of cells is B5:B33 would like to know how many times a number shows up that is 124 but <150 |
|
#3
|
|||
|
|||
|
=COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150)
No need for the '&' bits unless you putting in cell references in place of those numbers =COUNTIF(B5:B33,"124")-COUNTIF(B5:B33,"=150") -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Max" wrote in message ... Try either: =SUMPRODUCT((B5:B33124)*(B5:B33<150)) or: =COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150) -- Rgds Max xl 97 --- Please respond in thread xdemechanik <atyahoo<dotcom ---- "ChrisC" wrote in message ... How do I count the number of times a number is between two numbers? range of cells is B5:B33 would like to know how many times a number shows up that is 124 but <150 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
|
#4
|
|||
|
|||
|
Thanks for the refinement, Ken !
Guess softcoding habits die-hard <g -- Rgds Max xl 97 -- Please respond, in newsgroup xdemechanik <atyahoo<dotcom --- |
|
#5
|
|||
|
|||
|
LOL :-)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Max" wrote in message ... Thanks for the refinement, Ken ! Guess softcoding habits die-hard <g -- Rgds Max xl 97 -- Please respond, in newsgroup xdemechanik <atyahoo<dotcom --- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
|
#6
|
|||
|
|||
|
Thanks, this work great!
"Ken Wright" wrote: =COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150) No need for the '&' bits unless you putting in cell references in place of those numbers =COUNTIF(B5:B33,"124")-COUNTIF(B5:B33,"=150") -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Max" wrote in message ... Try either: =SUMPRODUCT((B5:B33124)*(B5:B33<150)) or: =COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150) -- Rgds Max xl 97 --- Please respond in thread xdemechanik <atyahoo<dotcom ---- "ChrisC" wrote in message ... How do I count the number of times a number is between two numbers? range of cells is B5:B33 would like to know how many times a number shows up that is 124 but <150 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| Sum and Count Function | Excel Worksheet Functions | |||
| how do I make a function to count days? | Excel Worksheet Functions | |||
Linear Mode
