I just found a very good tip at Chandoo's blog, how you can sum many ranges with multi-select.
![Excel ranges](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/id29dd3ee317361de/version/1457967605/excel-ranges.png)
You have to select each sum-row with CTRL and press ALT + = (ALT & Shift & 0). Now every sum-row has it own =sum() formula.
![Excel sum](https://image.jimcdn.com/app/cms/image/transf/dimension=351x10000:format=png/path/s1c89cca4309ebad9/image/i188bf07e8515b519/version/1457967602/excel-sum.png)
These posts might also be interesting:
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=jpg/path/s1c89cca4309ebad9/image/ifbcbd6254b84b440/version/1579612443/image.jpg)
SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/iceb7c340a3cdfd11/version/1547207729/image.png)
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains
299 Pages.
37,00 €
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/i33303fc1b6cc6323/version/1522747916/image.png)
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains
272 Pages.
27,00 €
Write a comment