jakester
Mar 6, 2010, 07:34 AM
I'm trying to figure out a way to Sum charges based upon date criteria and charge type criteria. Here's my problem.
I keep a spreadsheet for personal finances. I use codes for different charges to easily sum and keep track of categories. Here's what it would look like:
Date Description Amount Code
1/15/10 Groceries $50.00 GROC
1/21/10 Gas $22.50 GAS
At the end of each month, using a SumIf function, I am able to sum all charges based upon the code but I've been starting fresh each month and deleting the previous month data. I'd like to just keep entering the charges into my spreadsheet and roll up the charges for each given month. Can I add another condition to my sumif function that will sum for a given date period (Jan 1 - Jan 31, Feb 1 - Feb 28) based upon that particular code?
Thanks.
I keep a spreadsheet for personal finances. I use codes for different charges to easily sum and keep track of categories. Here's what it would look like:
Date Description Amount Code
1/15/10 Groceries $50.00 GROC
1/21/10 Gas $22.50 GAS
At the end of each month, using a SumIf function, I am able to sum all charges based upon the code but I've been starting fresh each month and deleting the previous month data. I'd like to just keep entering the charges into my spreadsheet and roll up the charges for each given month. Can I add another condition to my sumif function that will sum for a given date period (Jan 1 - Jan 31, Feb 1 - Feb 28) based upon that particular code?
Thanks.