This is agreat video! thanks! - I have something similar but I have it all in 1 sheet and its weekly, so I'm able to forecast and see it all. The difficulty I'm having is summarising it. For example, I'd like to know the income and expenditure month by month and to calculate the pecentage of what I'm earning, saving etc. I have looked at your SUMIFS video (also great) but Im not sure about the alignment of the dataset. Does it matter if it's horizontal or vertical for formulas to work?
Great!!!
Thank you, Roger 🙏👍
This is agreat video! thanks! - I have something similar but I have it all in 1 sheet and its weekly, so I'm able to forecast and see it all. The difficulty I'm having is summarising it. For example, I'd like to know the income and expenditure month by month and to calculate the pecentage of what I'm earning, saving etc. I have looked at your SUMIFS video (also great) but Im not sure about the alignment of the dataset. Does it matter if it's horizontal or vertical for formulas to work?
can you upload the file maybe?