Good morning
I was wondering if this is possible. I am setting up a 13 month Weekly Cashflow and I want to populate one tab with all my regular bills like Leases, Rates and Utlilities. At the moment I have the following formua that is working perfectly to pull in the last months data that I have entered;
=-(SUMIFS('Input income costs'!$J:$J,'Input income costs'!$G:$G,$B21,'Input income costs'!$H:$H,F$20) + SUMIFS('Input income costs'!$J:$J,'Input income costs'!$G:$G,$B21,'Input income costs'!$H:$H,$E$4))
In cell E4 I have put Every Month but can work out a way just to return the figure once in a month - this just returns the figure every week which idoes not really help - the set up of my front sheet looks a bit like this;
On my Input income cost Tab I would ike to enter my Lease payments for the past month and next 12 but only want to see the figure pop into the Cashflow once a month on specific date within each month.
Hope this makes sense and if it does is it possible?
I was wondering if this is possible. I am setting up a 13 month Weekly Cashflow and I want to populate one tab with all my regular bills like Leases, Rates and Utlilities. At the moment I have the following formua that is working perfectly to pull in the last months data that I have entered;
=-(SUMIFS('Input income costs'!$J:$J,'Input income costs'!$G:$G,$B21,'Input income costs'!$H:$H,F$20) + SUMIFS('Input income costs'!$J:$J,'Input income costs'!$G:$G,$B21,'Input income costs'!$H:$H,$E$4))
In cell E4 I have put Every Month but can work out a way just to return the figure once in a month - this just returns the figure every week which idoes not really help - the set up of my front sheet looks a bit like this;
Costs (£) | Total | 17-Jan-21 | 24-Jan-21 | 31-Jan-21 | 7-Feb-21 | 14-Feb-21 | 21-Feb-21 | 28-Feb-21 | 7-Mar-21 | |
Loan repayments | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
Suppliers | (£507,358.41) | (£149,457.82) | (£142,977.81) | (£214,922.78) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
Direct Debits | (£337,152.02) | (£78,891.34) | (£64,943.19) | (£193,317.49) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
Credit Cards | (£50,660.36) | (£50,660.36) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
On my Input income cost Tab I would ike to enter my Lease payments for the past month and next 12 but only want to see the figure pop into the Cashflow once a month on specific date within each month.
Hope this makes sense and if it does is it possible?