| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells between ranges
How do I count the number of cells that have values between for example $1000
and $2000? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
"Jason30" wrote:
How do I count the number of cells that have values between for example $1000 and $2000? One way is to use 2 countifs .. Assuming source data in col A, placed in say, B1: =COUNTIF(A:A,"=1000")-COUNTIF(A:A,"2000") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
Jason30 wrote:
How do I count the number of cells that have values between for example $1000 and $2000? If your range is A1:A100, you could use this formula: =COUNTIF(A1:A100,"<="&2000)-COUNTIF(A1:A100,"<"&1000) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
=COUNTIF(A1:A100,"=1000")-COUNTIF(A1:A100,"2000")
or =SUMPRODUCT(--(A1:A100=1000),--(A1:A100<=2000)) both formulas include 1000 and 2000, if you really want between use "1000" and "=2000" in the first and 1000 and <2000 for the last -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Jason30" wrote in message ... How do I count the number of cells that have values between for example $1000 and $2000? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
=countif(a1:a10,""&1000) - countif(a1:a10,""&2000)
is one way. (I'm not sure what should happen at 1000 and 2000, though. You may want to change the to = in either or both (or none).) Jason30 wrote: How do I count the number of cells that have values between for example $1000 and $2000? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
Thanks for the replies guys
"Jason30" wrote: How do I count the number of cells that have values between for example $1000 and $2000? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells between ranges
"Jason30" wrote:
Thanks for the replies guys You're welcome, Jason! Thanks for the feedback .. Ahh, if only every original poster was like you .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| including two ranges of cells in an IF formaula | Excel Worksheet Functions | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
