countif functions
I think you do want to subtract the second range. Let's consider your
example a little deeper. You have 12 cells, 2 are in the range 10-20.
Suppose 4 are in the range 20+. Then there would be 6 in the range 10+. So
6 (in the 10+ range) minus 4 (in the 20+ range) leaves 2 in the target 10-20
range. That's pretty much what the suggested formula does: count the 10+'s
then subtract the 20+'s.
"bsantona" wrote:
but I don't want to minus the cells, I just want a count of how many cells
are between the data range, for example I have 12 cells of which 2 have data
between 10 - 20 so the formula should return 2.
Please help
"bpeltzer" wrote:
That would be the count of cells =10 minus the count of cells 20. So
=countif(a:a,"=10")-countif(a:a,"20"). (Note that this includes cells
equal to 10 and those equal to 20; if you only want one endpoint included,
adjust the comparison operators accordingly).
HTH. --Bruce
"bsantona" wrote:
I'm trying to get a count of cells that have a range of data for instance I
want a count of cells that have data between 10 - 20.
Any ideas would be appreciated.
|