Excel 2008 : Sort by date

[madrat27]

Hey,


I'm familiar with Excel. I know how to import a function and to make a graph.
I'm trying to make a table with my monthly expenses.
I've got to columns: 1 the dates 2 my expenses on that date

Now what I want is something that gives me the sum of all my expenses in a month.
So you would have table of that would describe each month with its total expenses.

I hope someone can help me,


thanks

[DonkeyOte]

Use a Pivot Table (or Pivot Chart if preferred) - set your Date Field as Row Field and Group the Date by Month & Year, set Expenses as Data Field set to SUM.

for more info. on Grouping see: http://www.contextures.com/xlpivot07.html

[madrat27]

thanks

I'll try that