Learn Microsoft Excel On Steemit :- How To Sum Numbers In Excel Sheet.

in Steem For Bangladeshyesterday

Polish_20250718_113549604.jpgThumbnail photo


Assalamu Alaikum friends, I hope you are all well, by the grace of Allah I am also well. It is very fortunate for us that we are learning new topics every day on the Steemit platform. Although there is no end to learning and there is no age to know. I always like to share new topics on this platform. So today I thought of bringing you a Microsoft Excel tutorial. This tutorial is just to teach you and I can practice more deeply myself. Today I will teach you how to find the sum of numbers in a Microsoft Excel sheet on a computer or laptop. We use Microsoft Excel during various tasks. For this, it is important to find the sum from our database. Let us see from the beginning how to find the sum in a few ways.

  • First, install Microsoft Excel on your computer. I have installed Excel 2016 which you can see on my computer screen.

IMG_20250718_091736.png


  • After opening the Microsoft Excel application, you will be presented with an interface like this. Since you will be starting from scratch, the first option you need to click on is the Blank Workbook option. This will open a new Excel workbook.

IMG_20250718_091840.png

Screenshot (37).png


Let's now know the internal options. The letters you see above, A, B, C, D, F, G, H..... are called columns. They are used as columns from top to bottom.

IMG_20250718_092052.png


  • Let's now see what the letters next to each other are called. Then the numbers 1,2,3,4,5,6... that you see on the left side are called rows.

IMG_20250718_092009.png


  • Now you can see small boxes below or around these, these are basically known as cells. Here, when you click on each cell, the name of the cell is shown on the top left.

IMG_20250718_092125.png


  • Let's get started. You can write anyone's name in Excel. You can write any name from the right side of the number. That's why I wrote the first part of my own Steemit username. I wrote my name from 2 to 8, you can write any other name.

IMG_20250718_092219.png


  • Since I wrote the name in the letter A, I added a number or amount in the letter B. I wrote 10,20,30,40,50,60,70 to make it easier to understand.

IMG_20250718_092307.png


  • Now you can sum these numbers in several ways. Look at the right side of the laptop where I have marked. There is an option called Autosum which if you click on it will automatically calculate the sum. After clicking on the Autosum option, you will see that the automatic lookup result has been calculated and 280 results are showing from all the numbers.

FIRST SUM METHOD ➤

IMG_20250718_092439.png

IMG_20250718_092522.png


SECOND SUM METHOD ➤

  • Now you can find the sum manually below the numbers. For this you need to type this command from your keyboard in the box below the last number.
  • =SUM(B2+B3+B4+B5+B6+B7+B8)

IMG_20250718_092650.png

  • Now Press Inter From The Keyboard

IMG_20250718_092727.png


THIRD SUM METHOD ➤

  • Besides, you can also find the sum of the third rule. For this you need to type a command by clicking on any box or cell. It is..

  • =SUM(B2:B8)

IMG_20250718_092802.png

  • Now Press Inter From The Keyboard

IMG_20250718_092837.png

So this is how the sum of the numbers is determined. You can determine the sum of any number in the above three rules. But your laptop should have Microsoft Excel installed correctly.


I think this post will be useful for many of you who want to learn Microsoft Excel. There are many users who have computers but they cannot calculate the sum in Microsoft Excel. Today I have taught you very easily how to calculate the sum easily with Microsoft Excel. Here I have told you three ways by which you can easily calculate the sum in any rule. I hope you liked my blog.

Sort:  

Hello @max-pro! 👋

Congratulations! This post has been upvoted through @steemcurator05. We support quality posts, good comments anywhere, and any tags.



Curated by: mohammadfaisal