Hello, I am trying to stratify amounts in a given range of cells into
different tiers.

I have a range of $ values. Lets say from A1:E100 that is filled with
numerical values.

I am trying to summarize this data into tiers, for example
sum of amounts: from 10,000 to 15,000
sum of amounts: from 5,000 to 9,999
sum of amounts: from 0 to 4,999
sum of amounts: from (1) to (4,999)
sum of amounts: from (5,000) to (9,999)
sum of amounts: from (10,000) to (14,999)

How do I do this?