Hi all,
I am working on a Spreadsheet that I would like to post income/expenses to a row and keep weekly, monthly and year to date cells. It seems to be a problem, I would like to keep a cell for posting the weekly expenses and total it in the monthly cell and also keep a total of year to date. I post the amount to the weekly cell and I can total in either the monthly or the ytd cell, but not both.
Any ideas are greatly appreciated.

For example: A5 is source. B5 is the weekly amount. C5 would the the monthly amount, and D5 would be the year to date .