Strategizing numbers
 

I have a wide range of varying dollar amounts that I want to group together
depending on the range in which they fall. I need a percentage of how many
figures fall into each range.What would be th best way to do this?

Example:

Values:
$1,765.02
$568.71
$1,141.22

Ranges-
$549.99-599.99
$600.00-649.99
$650.00-699.99 etc.

Strategizing numbers
 

Look at SUMPRODUCT examples in this discussion forum...

If you have your nos in A1:A100 and ranges in B & C cols then
Type in D1
=SUMPRODUCT(--(A1:A100B1),--(A1:A100<C1))
and press CTRL-SHIFT-ENTER and copy down

"infinite1013" wrote:

I have a wide range of varying dollar amounts that I want to group together
depending on the range in which they fall. I need a percentage of how many
figures fall into each range.What would be th best way to do this?

Example:

Values:
$1,765.02
$568.71
$1,141.22

Ranges-
$549.99-599.99
$600.00-649.99
$650.00-699.99 etc.

Strategizing numbers
 

See help on the FREQUENCY function.


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 08:32:01 -0700, infinite1013
wrote:

I have a wide range of varying dollar amounts that I want to group together
depending on the range in which they fall. I need a percentage of how many
figures fall into each range.What would be th best way to do this?

Example:

Values:
$1,765.02
$568.71
$1,141.22

Ranges-
$549.99-599.99
$600.00-649.99
$650.00-699.99 etc.