guitarist_wo
New Member
- Joined
- Sep 20, 2006
- Messages
- 7
Ok, I have a finances spreadsheet that I want to put all of my expenses during a given month. I want to be able to automatically update a cell with the month depending on the date I enter in to a different cell. For example, I enter a date in a cell (9/20/06). To the right of that under my "Bills" column, I would enter in $50. Then, the next row, 5 days later I enter this date (9/25/06) with a payment of $30 in the column to the right. Then, my next payment is next month (10/5/06) of $70.
I want to update a different part of my spreadsheet automaticaly that has the total montly payments. So, for that part of the spreadsheet under the September row for "Bills", I would have a total of $80. For the October row, I would have $70. In words, I want the formula to say this: "If this date in this cell equals the month of 9, then I want this cell, which is to the right of my date that holds the amount, to update in the September row under my Bills column". I'm not quite sure how to do that and whether it has to be a macro or just a formula. Its hard to explain exactly what I want, but I hope my description helps. Any help would be greatly appreciated. THANKS!
I want to update a different part of my spreadsheet automaticaly that has the total montly payments. So, for that part of the spreadsheet under the September row for "Bills", I would have a total of $80. For the October row, I would have $70. In words, I want the formula to say this: "If this date in this cell equals the month of 9, then I want this cell, which is to the right of my date that holds the amount, to update in the September row under my Bills column". I'm not quite sure how to do that and whether it has to be a macro or just a formula. Its hard to explain exactly what I want, but I hope my description helps. Any help would be greatly appreciated. THANKS!