Know More about AutoSum option in MS Excel

By -
Today, when I was working with MS Excel then I used the AutoSum option many times to make sum of the numbers. I have noticed one thing about this option which was very interesting. This option is available in two places, first in Home tab and second in Formulas tab. Check the images below:

 
   AutoSum in Home Tab                                           AutoSum in Formulas Tab

Shortcut for AutoSum:

In MS Excel, every formula and function have its own shortcut. You can use ALT+ as the shortcut of AutoSum option. To test this option, write down the numbers in the excel sheet and press ALT+ to make its AutoSum. Now I am describing my experience with this function.

First I have created three columns named: Physics, Chemistry and English. Now I entered some numbers along with the columns.


Test of AutoSum Option

Vertically Up: Excel user may use‘=sum(number1,number2)’ formula or AutoSum option to sum-up the data. When I tried the AutoSum option in vertically up then it gives me the following result:


After this option, I pressed the Enter key to get my answer. The answer was correct.

Vertically Left: In this situation, I have selected the value of a single row and apply the AutoSum on it.I found the result like this:


I pressed Enter key and got my answer.

Vertically Down: Now, I was trying to test the AutoSum vertically down. In this case, the AutoSum option was not proving the range of the data cells. Check the image below:


So this is the one limitation with AutoSum option.

Vertically Right: The AutoSum option was not working in this situation. When I tried, then I got only the formula, not the range of numbers. Take a look:


So, Thing option doesn’t work in this situation.

Blank Cell in Numbers: If you have the blank cell in the numbers then, the AutoSum option will not take the values before it. This is also a limitation of this function.


So, we have seen the AutoSum function in the very different levels and the limitations of this function. I hope you like it. If you have more information about it then please share with me.

Comments

Post a Comment

Popular posts from this blog

Simple Tips to Fix Bookmark Not Defined Error

By -
Image
Bookmark not define error occurs in the large size word document. The main reason of this error is broken link to into the bookmark. It is also related to TOC (Table of Content) and some user complaint this error during updating of TOC. The complete error message is: “ Error! Bookmark Not Defined. ” or “ Error! Reference source not found. ” Important Tip: If you get the same error then press Ctrl+Z to undo action. It works instantly on the document but not worked when you perform any other operations and save the document. Let’s see some reliable solution to fix it! Solution 1: If you are trying to merge the content into a new document, then unlink them before doing it. This process converts TOC field to actual text and tries to prevent it from any update. If you want to update the TOC, you must reinsert it. Steps to unlink the table of contents: Place insertion point within the table of contents. Press ctrl+shift+f9 (for Windows), or the command key+shift+f9 (for
Read more

5 Powerful Solutions to Fix QuickBooks Error 6177

By -
Image
Error 6177 occurs when QuickBooks software does not recognise the path to open the company file. This is the primary reason but, other reasons can also be cause for this error. Let’s discuss some important solution to fix this error. Solution 1: Move your company file to hard-drive Change the location of your company file from a server or any other drive to C drive. Now open the file from there. Create a portable file and save the company file in local drive. Close the company file. Now, restore your portable file from C drive and save to server. Select company file and open it from server. 5-powerful-solutions-to-fix-quickbook Solution 2: Update the QuickBooks version Visit the product page of QuickBooks and update with the latest release. Always update all the updates: manual & automatic to protect the QuickBooks from unwanted error. Solution 3: Manually Fix Follow these steps to manually fix the QuickBooks error 6177 Open the folder that contains company
Read more

How to solve “This document may be damaged (the file may be truncated or incomplete)” JPEG image error

By -
Image
JPEG image or any file type images are very sophisticated, If one pixel of your image get damaged or corrupt then that portion of image will get change. If header part of your image gets damaged then your image will not open. There are several reasons for corruption of JPEG images like virus attack, improper system shutdown etc. In the case of JPEG file corruption you need to repair it with some good JPEG repair software to access your image properly. These are some error messages which you may get in the case of images corruption. Different image viewer will show different message. In Windows Explorer “No Preview Available”. Windows Picture & Fax Viewer will show “Drawing Failed” message. Adobe Photoshop will show “This document may be damaged (the file may be truncated or incomplete)” message. In IrfanView “Can't read file header! Unknown file format or file not found!”. Adobe Photoshop “Could not complete your request because an unkno
Read more