Let excel do math for you regardless of whatever condition you are in. From planning the monthly budget of a common man to balance sheet of an organization, Autosum in excel is a one-click tool in Microsoft Excel that runs functions on a list of data. A handy yet powerful function in Microsoft Excel that can automatically add up a range of cells quickly by saving your time. It’s often faster than creating a formula when you have large sets of data to add up.
I prepared a list of data that I want to add up and let us see, how to do that.
1. In the below scenario, we need to know how much sales we have done at the end of the year for individual location and let’s look how we shall use this AutoSum function.
2. Instead of typing the sum formula, on the right hand side of the home tab, you will be able to find the option AutoSum. Now, click on the dropdown and you shall find several options such as sum, average, count, max, and mind. As we are looking up for the total, select the sum option
3. When you chose the option of Autosum from the ribbon, it automatically guess the range of cells to be added. You can even change the range, it is mutable.
4. Hit enter and you shall receive the sum of the entire column you have selected. There you go.
Likewise, you can perform other operations by selecting the respective option in the AutoSum dropdown.
Things to remember while using AutsoSum function in Excel:
● Autosum can only go up or left, not right or down.
● You can also press ALT+= (on Windows) or Option+Command+= (on Mac) as an alternative to clicking the Autosum button on the toolbar.
● Autosum stops when it encounter an empty cell or a cell that doesn't contain a number.
● Autosum stops functioning when it hits any non-numeric value in your range. Strictly speaking, the Autosum formula will work but the error will stop it calculating the result
EduPristine is a member of Adtalem Global Education (NYSE: ATGE), a global education provider headquartered in the United States. Adtalem is a 3 billion dollars (20,000 crores) company that has about 9 institutions and companies with more than 16,000 employees spread across 145 locations. Adtalem takes pride in training 142,000 degree-seeking students all over the world.The organization's purpose is to empower students to achieve their goals, find success and make inspiring contributions to our global community. EduPristine is one of India's leading training providers in Analytics, Accounting, Finance, Healthcare, and Marketing. Founded in 2008, EduPristine has a strong online platform and network of classrooms across India and caters to self-paced learning and online learning, in addition to classroom learning