excel: How to set up a formula for a range of numbers ie. 3.5-5..
"LadyK974" wrote:
in a spreadsheet i have a range of numbers that needed
to be counted ie. phos levels between 3.5-5.5 I can't
find a formula to support this.
You're a little light on details. A concrete example might help to ensure a
clear understanding of your needs.
If you have "phos levels" in the range A1:A100 and you want to determine how
many are between 3.5 and 5.5 inclusive, then:
=sumproduct((3.5=A1:A100)*(A1:A100=5.5))
Note: This assumes that A1:A100 contains numbers, not text.
|