[Solved] auto sum with date dependency

[ririz99]

Hello,

I have an excel spreadsheet which I used to keep track of some records. A sample as below:

ColumnA ColumnB
Row1 07/09/09 5
Row2 08/09/09 -2
Row3 13/09/09 10
Row4 02/10/09 12
Row5 31/01/10 -22
...
...
...
Row100

Column A is where I put a date in ddmmyy format.
Column B is an integer value

Appreciate if someone could write a formula that does the following:

1. Ability to scan row1 to row100 on columnA, return me the sum of the integers from columnb for that month. Note, some months there are more than 1 record and some months there are 0 records.

The results should look something like this:

Sep-09 13
Oct-09 12
Nov-09 No records
Dec-09 No records
Jan-10 -22

If there are months with 0 records then I want the text "No records' to appear.

Tks
ririz99

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time only!

[royUK]

Probably a PivotTable would work,attach an example workbook

[ririz99]

Attached a sample spreadsheet...

[royUK]

Here's a quick example using subtotals & a PivotTable

[ririz99]

Hi Admin (royUK),

Thanks for pointing me in the right direction, about using pivot table. While I must admit I didnt really understand how it was done in the sample worksheet, I managed to dig deeper into pivot tables functionality and eventually I was able to create what I wanted from scratch!

Thank you!

Rgds