Strategizing numbers

[infinite1013]

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.

 

[Sheeloo]

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:A100>B1),--(A1:A100<C1))
and press CTRL-SHIFT-ENTER and copy down

 

[Gord Dibben]

See help on the FREQUENCY function.


Gord Dibben MS Excel MVP