Firstly, I have been reading this board for a number or weeks, and have to say I have great admiration for the helpfulness and expertise of many of the contributors. I have so far leaned many new tips.
However, i've got a problem I can't quite solve. I've been stuck for the last few hours, and have only half found a solution by some useful advice posted on http://www.cpearson.com/excel/array.htm. but can't get it to work with dates.
The problem...
Users enter trading data on a day by day and trade by trade basis.
I need to summarise this data in another worksheet, but on a monthly basis
The data...
INPUT SHEET
A B
1 Date Amount
2 6 Apr 03 500
3 6 Apr 03 200
4 7 Apr 03 100
5 10 May 03 300
(dates input as Excel date format) This is only a simple representation - the actual input sheet has many more entries in per month.
OUTPUT SHEET
A B
1 Date Amount
2 Apr 03 800
3 May 03 100
4 Jun 03 -
etc
The formula I have been trying in B2 is:
This is only a simple representation - the actual input sheet has many more entries in per month.
What
However, i've got a problem I can't quite solve. I've been stuck for the last few hours, and have only half found a solution by some useful advice posted on http://www.cpearson.com/excel/array.htm. but can't get it to work with dates.
The problem...
Users enter trading data on a day by day and trade by trade basis.
I need to summarise this data in another worksheet, but on a monthly basis
The data...
INPUT SHEET
A B
1 Date Amount
2 6 Apr 03 500
3 6 Apr 03 200
4 7 Apr 03 100
5 10 May 03 300
(dates input as Excel date format) This is only a simple representation - the actual input sheet has many more entries in per month.
OUTPUT SHEET
A B
1 Date Amount
2 Apr 03 800
3 May 03 100
4 Jun 03 -
etc
The formula I have been trying in B2 is:
This is only a simple representation - the actual input sheet has many more entries in per month.
What
