Summing data dependent on month

Resolved · High Priority · Version 2013

Thu 27 Apr 2017, 13:38 Delegate Sara said...

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! :)

Thu 27 Apr 2017, 14:15 Trainer Jens said...

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