How to calculate the sum of cells in excel in several cool ways?

Good day to all, my dear friends and guests of my blog. As always and as usual, I am with you, Dmitry Kostin. And today I would like to continue our communication with Excel, because it is really a necessary thing and will always come in handy in the household. For example, I can't imagine my life without this spreadsheet editor.

I currently maintain several spreadsheets for different purposes, not counting those that we maintain together with the guys from the department using the Google Docs service. I have a spreadsheet that sums up my income versus expenses for the blog, and I also keep financial records of spending planning and family budgeting, and a bunch of other paperwork.

Yes, of course, there are special programs for such purposes, but to be honest, they do not suit me in everything in terms of functionality, and in excel I can customize everything for myself, as I wish. The scope for this is just huge. Moreover, the documents themselves are possible, which makes working in this editor even more reliable, easier and more convenient. In general, I won’t torment you, but I’ll just tell you how to calculate the sum of cells in Excel

Let's start with a light warm-up. If you need to calculate the sum of some numbers, then the simplest thing is to do a simple example. To do this, stand on any cell and write an equal sign (=), after which start adding the necessary numbers (=15+6+94+3-10+2). The final touch you will need to press the key Enter, then this whole mathematical example is lightning-fast converted into a solved answer.

Addition of each cell

To begin with, we will learn how to add just a few numbers that can be in different places.

Column summation

Now let's move on to the simplest and most delicious. Yes, now you will learn how to sum a column.

Select a column or part of it, then go to the "Formulas" tab and select the item there "Autosum". After this simple manipulation, you will see the sum of all the numbers you selected. It will automatically fit into the nearest free cell in your column.

In fact, it doesn't even have to be a column. It can be either a line or individual cells (you can select it with the pressed key CTRL). Only the place where the result will appear will be different.

Using a formula with the SUM option

This method is especially good when you need to enter the result in a specific cell. At least I use it that way and I'm happy as an elephant. Let's show.

By the way, you can use the same method to calculate the sum of cells from different sheets. Let's talk a little more.

Summation from different sheets

Everything, now despite the fact that the numbers are in different places, the amount is calculated. This feature makes this spreadsheet editor even more convenient.

What I especially like about excel is that you can change formula parameters on the fly. For example, if we need to reduce one of the participating numbers by two units, then the entire amount will decrease by two accordingly. I often use this stuff in my daily life.

Well, that's about all I have. If there are any misunderstandings, please ask. I will be happy to answer your questions. I also recommend that you subscribe to my blog updates to always be aware of everything new and interesting. See you in other articles. Bye bye!

Sincerely, Dmitry Kostin.