How do I sum expense values depending on the month

  • Thread starter Thread starter chrisjleu
  • Start date Start date
C

chrisjleu

If I have a typical income and expenditure sheet with an expenditur
column and the date of the expenditure like so:

Date Expense_value

17/05/2004 £12.00
18/05/2004 £11.00
19/05/2004 £25.00
27/05/2004 £12.00
01/06/2004 £15.00
05/06/2004 £13.00


and I want to have another table that looks like this:

Month Total_expenditure
May £60.00
Jun £28.00

How do i do it?

I'm sure this is a typical use of an excel spreadsheet but i'm a novic
and don't know where to start.

Thanks
 
I suugest you use another column (Say Column C.Hidden if necessary) with
formula =MONTH(A1) then use =SUMIF() to get the month total. Something
like, for May :-

=SUMIF(C1:C17,5,B1:B17)
 
Back
Top