If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to display the sum of my monthly expenditure...
I have a date column and an expense column, so all my expenses on a
particular day are recorded. On another sheet, i want to display a list of months and have the sum of my expenses for each month in the adjacent cell. Sounds simple enough right. I thought of using the MONTH function somehow but its useless, ican't get it to work. Even after reading the manual i can't understand it. Can anyone tell me the way to do this. Date Expenditure 26-Apr-2004 20 26-Apr-2004 34 26-Apr-2004 12 26-Apr-2004 32 02-May-2004 11 04-May-2004 53 04-May-200411 04-May-2004 11 05-May-2004 23 05-May-2004 24 The problem I have I think is getting excel to extract the month from the 'date' column. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|