Summary of Amounts by Date

[gelert64]

Hi there everybody. I am new to this group and would appreciate a littl
guidance. I have created a Spreadsheet for my Partner and on the secon
tab I would like to total her spend by Month. Could anyone please guid
me on how to total by the dates in the first Sheet.

Thanks very much Richard

I have attached the spreadshee

+-------------------------------------------------------------------
|Filename: Sarah.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=621
+-------------------------------------------------------------------

 

[Claus Busch]

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

 

[Claus Busch]

Hi,

or do it with Pivot-Table. Date in rows and group for year and month


Regards
Claus Busch