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

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

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