countif functions
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.
|