Simple sorting formula

fredmcted

Board Regular
Joined
Sep 13, 2012
Messages
50
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 useageregisteredservicecost
11/1/1221ypart 1500
14/1/1216npart 2250
12/2/1242ypart 1500

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,076
Office Version
  1. 2010
Perhaps a Pivot Table will do the trick?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top