# excel: How to set up a formula for a range of numbers ie. 3.5-5..

Guest
Posts: n/a

 26th Apr 2010
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

Joe User
Guest
Posts: n/a

 26th Apr 2010
> 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

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.

Ashish Mathur
Guest
Posts: n/a

 27th Apr 2010
Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LadyK974" <(E-Mail Removed)> wrote in message
news:EC136C51-ED3D-4761-B13C-(E-Mail Removed)...
> 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

David Heaton
Guest
Posts: n/a

 27th Apr 2010
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. Can you
> help

Maybe have a look at the frequency formula.

It takes the range of values you have then a range of bins (interval
values, 2.5,3,3.5,4,4.5, etc) and returns the number of values that
fall within each bin

Regards

David

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post tkw Microsoft Excel Misc 2 1st Oct 2009 09:17 PM =?Utf-8?B?YXJzb3ZhdA==?= Microsoft Excel New Users 2 30th Oct 2006 09:21 PM mike_c70 Microsoft Excel Misc 3 31st Aug 2004 04:12 PM Frank Jones Microsoft Excel Programming 12 10th Jun 2004 04:22 AM Keith R Microsoft Excel Programming 2 11th Aug 2003 05:55 PM

Features