count number of cells in range showing between 320 and 345
You could also use two countif functions:
=countif(A:A,"320")-countif(A:A,"=345").
The first countif tallies up those entries that are over 320; the second
backs out those at least 345, leaving only those between 320 and 345.
"annieandtika" wrote:
What formula do I use to count the numbers of cells in a range which return a
value of greater than 320 and less than 345?
|