I have a very large spreadsheet that will show daily expenses for over 2 years.
I want to be able to quickly enter regularly recurring expenses and see daily totals. I then plan to add income later and calculate daily cash-flow.
I though I had found a suitable formula and everything seemed to be working fine but then Excel error message says "This formula can't be entered because it uses more than 64 levels of nesting."
This sheet matches the dates in the payments columns from columns F to HE with the dates in daily expenses from Columns HH to ASV.
If the dates match, the amounts in columns F to HE get entered into the correct cells in Columns HH to ASV.
I am not allowed to attach my Excel spreadsheet for some reason but I have included a screen-shot below.
Is there a different formula that I can use that will do the exact same thing?
Or is there a better way to enter recurring expenses into a spreadsheet and then be able to see this daily?
This will be the foundation for an extremely detailed daily cash-flow spreadsheet.I will then display the daily totals on an easy to read yearly calendar.
To fit everything into the screen-shot I have had to hide a lot of the columns, but hopefully you will see what I am trying to do.
I want to be able to quickly enter regularly recurring expenses and see daily totals. I then plan to add income later and calculate daily cash-flow.
I though I had found a suitable formula and everything seemed to be working fine but then Excel error message says "This formula can't be entered because it uses more than 64 levels of nesting."
This sheet matches the dates in the payments columns from columns F to HE with the dates in daily expenses from Columns HH to ASV.
If the dates match, the amounts in columns F to HE get entered into the correct cells in Columns HH to ASV.
I am not allowed to attach my Excel spreadsheet for some reason but I have included a screen-shot below.
Is there a different formula that I can use that will do the exact same thing?
Or is there a better way to enter recurring expenses into a spreadsheet and then be able to see this daily?
This will be the foundation for an extremely detailed daily cash-flow spreadsheet.I will then display the daily totals on an easy to read yearly calendar.
To fit everything into the screen-shot I have had to hide a lot of the columns, but hopefully you will see what I am trying to do.