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!