SandieConfused
New Member
- Joined
- Apr 12, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a workbook with
1. A data entry sheet - invoice date, income amount, debit amount,paid date and income category and debit category. Invoices are not always paid in the financial year they were received or issued.
2. An information sheet which includes: Variables Names: YearEnd and YearStart have been defined on an Information and bank balance at the start of the year
3. Various analysis sheets, for example total income and expenditure by month and income and expenditure by category - these are easy to do with Pivot tables.
I want to have a sheet which reflects the actual cashflow during the month. To do this I need to total the figures depending upon when the invoice was sent/received - something like the format below:
I've tried SUM and INDIRECT which will sum everything from either the debit and credit column. But using SUMIF and INDIRECT I keep getting 0 or an invalid formula.
Any ideas?
1. A data entry sheet - invoice date, income amount, debit amount,paid date and income category and debit category. Invoices are not always paid in the financial year they were received or issued.
2. An information sheet which includes: Variables Names: YearEnd and YearStart have been defined on an Information and bank balance at the start of the year
3. Various analysis sheets, for example total income and expenditure by month and income and expenditure by category - these are easy to do with Pivot tables.
I want to have a sheet which reflects the actual cashflow during the month. To do this I need to total the figures depending upon when the invoice was sent/received - something like the format below:
| Income | Expenditure | |||
| Brought Forward: | ||||
| April | ||||
| May | ||||
| … | ||||
| March | ||||
| Carried Forward: |
I've tried SUM and INDIRECT which will sum everything from either the debit and credit column. But using SUMIF and INDIRECT I keep getting 0 or an invalid formula.
Any ideas?
