Sara has attended:
Excel Intermediate course
Excel Advanced course
Summing data dependent on month
Hello!
I have a summary table of energy data from different buildings and I want it to cumulatively sum data as we move through the year.
Is this something that is possible? I have created a IF "" function, but this only works for the coming month.
Thanks! :)
RE: Summing data dependent on month
Hi Sara,
Thank you for the forum question.
You have a lot of options to cumulatively sum data. First it is a question about how your data are organised.
I have attached a workbook with some examples.
If you cannot see the attachment please refresh your browser (F5). If you still cannot see it. Please wait a couple of minutes and refresh the browser again.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
running sum.xlsx
