Prev: Formula Help
Next: Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible
From: LadyK974 on 26 Apr 2010 15:09
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. Can you
help
From: Joe User on 26 Apr 2010 15:34
"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.
From: Ashish Mathur on 26 Apr 2010 21:43
Hi,

Try this

=countif(range,">=3.5")-countif(range,">5.5")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LadyK974" <LadyK974(a)discussions.microsoft.com> wrote in message
news:EC136C51-ED3D-4761-B13C-BDE0EF32973A(a)microsoft.com...
> 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. Can
> you
> help

 | 
Pages: 1
Prev: Formula Help
Next: Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible