| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Summary of Amounts by Date
Hi there everybody. I am new to this group and would appreciate a little guidance. I have created a Spreadsheet for my Partner and on the second tab I would like to total her spend by Month. Could anyone please guide me on how to total by the dates in the first Sheet.
Thanks very much Richard I have attached the spreadsheet |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Summary of Amounts by Date
Hi,
Am Sat, 13 Oct 2012 09:30:55 +0000 schrieb gelert64: Hi there everybody. I am new to this group and would appreciate a little guidance. I have created a Spreadsheet for my Partner and on the second tab I would like to total her spend by Month. Could anyone please guide me on how to total by the dates in the first Sheet. in column A of sheet Monthly Breakdown: =SUMPRODUCT(--(MONTH(Summary!$A$2:$A$200)=COLUMN()),--(Summary!$E$2:$E$200)) and copy to right Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Summary of Amounts by Date
Hi,
or do it with Pivot-Table. Date in rows and group for year and month Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Amounts to Another Workbook Based on 2 Conditions - Date/Employee | Excel Programming | |||
| Sum amounts based on date field | Excel Worksheet Functions | |||
| Graphing calender chart with combined relative amounts for each date | Charts and Charting in Excel | |||
| How do I link 2 spreadsheets to insert amounts on a defined date? | Excel Worksheet Functions | |||
| Adding amounts based on a conditional date | Excel Discussion (Misc queries) | |||
Hybrid Mode
