Stuck! How do group these ranges with totals?

[mrdeflok]

Hi guys,


I have a column of about 17,000 numbers which I need to sort into ranged groups.

I can use sort to get the data manually but it is very time consuming.

Essentially, I want to group the data into ranges as below and get the sum total of each range along with the number of entries which comprise that range.

Ranges......................... Total $......................... # of Accounts
> $50
$25 - $50
$10 - $25
$5 - $10
$1 - $5
$.5 - $1
$.25 - $.5
$.1 - $.25
$.0 - $.1

I have been trying to use something like =SUMIF(A4:A17000,">50") but I am unsure how to get that to work for the next range where it needs to be >10 but <25.

Any help would be hugely appreciated!

[Logit]

Col D Formula:			
=SUMIFS(A2:A13,A2:A13,">50",A2:A13,"<500")			
			
Col E Formula :			
=SUMPRODUCT(($A$2:$A$13>50)*($A$2:$A$13<500))			
			
H2 Formula:			
=SUM(A2:A13)			
			
I2 Formula			
=SUM(D2:D10)

The formulas change slightly for each denomination range and # of Accts.

You will need to change the upper range of the formulas to match how many
rows you are using in your workbook. ex: instead of A13 perhaps A500.
.
.