If I have X,Y data how do I sum the Y values using a set of bins based on x values

[ScottBerger]

I have a complex (x,y) data set equivalent to this simplified example:

Years Experience (x) vs. Workhours (y)
1.3, 7
4.0, 6
4.2, 9
4.5, 3
5.0, 9
5.5, 3
7.1, 3
9.5, 18

I want to produce a set of Experience data bins where the total numbe
of workhours is calculated within each Experience bin, for example:

1, 7
2, 0
3, 0
4, 18 (Sum of y values when x is between 4 and 5)
5, 12 (Sum y values when x is between 5 and 6)
6, 0
7, 3
8, 0
9, 18


Any help would be greatly appreciated.

Scot

 

[Myrna Larson]

I would try a Pivot Table with Grouping.