Horizontal subtotals

Hi Kome,

Thank you for the forum question.

I have created a worksheet with an example how it can be done.

I am using an IF function and the Sumifs function to do it.

Please have a look at my example and let me know if this is what you need.


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