aggregate counts into pre-defined price ranges

[sarahrosenberg]

What is the easiest way to compose a sumif-type command that will sum the counts into pre-defined ranges? (see my example below)

Book2
	A	B	C	D	E
1	Before
2				After
3	price	count
4	$208.07	100		price	count
5	$176.13	1235		$100-$150	89
6	$165.76	563		$150-$200	5360
7	$174.88	773		$200-$250	709
8	$168.00	1588
9	$115.64	89
10	$171.74	268
11	$178.08	933
12	$219.49	582
13	$226.57	27
14
Sheet1

 

[KenWright]

The FREQUENCY() function was designed to do exactly this kind of thing.

 

[Brian from Maui]

There is some lesson in there, no? Always report the formulas also outside the exhibit.

I will......

 

[sarahrosenberg]

Awesome. Thanks. I learn so much cool stuff on this web site...And, at work, they all just think it is me!