Simple sorting formula

[fredmcted]

Hi All,
My brain has gone completely blank.
I've got a table of data which id like to extract certain results according to date.
So for example multiple people used the service within January, from this id like to work out the number of adults, if they were registered, total cost, what service. The way i was going to do it was to have a complicated IF formula and 12 columns which id then extract the data from. there must be a formula I'm missing and have overlooked. I hope you can help. FredMcTed

service use	age	registered	service	cost
11/1/12	21	y	part 1	500
14/1/12	16	n	part 2	250
12/2/12	42	y	part 1	500

<tbody>
</tbody>

 

[arthurbr]

Perhaps a Pivot Table will do the trick?