Here is my dilema,
I am attempting to create a full accounting spreadsheet for our rental property business. I have a check register
sheet in which a enter all receipts/disbursments each with an account and property designation. These figures
are posted to a cash flow sheet which can tell me how much has been spent at each property and with each account.
I came up with this formula off of some postings I found on your website:
=SUM(IF((Account!$G$103:$G$3004=D1)*(Account!$H$103:$H$3004="Advertising"),Account!$F$103:$F$3004)).
This is copied over to the other "intersections" on the cash flow sheet and works great.
The problem is that I have realised that I am going to also need to incorporate a date range into this formula.
My plan is to set up 12 worksheets in order to have 12 monthly cash flow reports. Even better would be to keep
the one cash flow report and have two cells with dates entered that would be referenced by the formula for the date
range. If I haven't confused you, any help would be greatly appreciated.
I am attempting to create a full accounting spreadsheet for our rental property business. I have a check register
sheet in which a enter all receipts/disbursments each with an account and property designation. These figures
are posted to a cash flow sheet which can tell me how much has been spent at each property and with each account.
I came up with this formula off of some postings I found on your website:
=SUM(IF((Account!$G$103:$G$3004=D1)*(Account!$H$103:$H$3004="Advertising"),Account!$F$103:$F$3004)).
This is copied over to the other "intersections" on the cash flow sheet and works great.
The problem is that I have realised that I am going to also need to incorporate a date range into this formula.
My plan is to set up 12 worksheets in order to have 12 monthly cash flow reports. Even better would be to keep
the one cash flow report and have two cells with dates entered that would be referenced by the formula for the date
range. If I haven't confused you, any help would be greatly appreciated.