![how to get a grandtotal sum in excel how to get a grandtotal sum in excel](https://i.ytimg.com/vi/-u-9f3QrdAQ/maxresdefault.jpg)
Here’s a list of function supported by Autosum: It will also put a grand total in the bottom-right corner of the selection.Įxcel’s AutoSum can be used to insert other functions apart from addition. This will put the column totals in the last row of the selection, and the row totals in the last column of the selection.Click the Autosum button from the advanced group in Home.Click on B2 and drag it all the way to F8 with your mouse. In the previous example, to add up the rows and columns at the same time:
#How to get a grandtotal sum in excel how to#
How to Autosum Rows and Columns at the same time Cells F2:F4 will have the sums for each month. Select cells F2:F4 by clicking on F2 and dragging it all the way to F4.
![how to get a grandtotal sum in excel how to get a grandtotal sum in excel](https://cdn.extendoffice.com/images/stories/doc-excel/show-grand-total-at-top/doc-show-grand-total-at-top-6.png)
In this example, you have the fruit sales for the first quarter of the year in a horizontal format.
![how to get a grandtotal sum in excel how to get a grandtotal sum in excel](https://study.com/cimages/videopreview/screen_shot_2015-01-13_at_7.14.12_pm_140016.jpg)
In the following example, you have the monthly sales for the first quarter of the year. You can use the autosum feature from two locations in the ribbon.Įxamples of Autosum How to Autosum a column in Excel In this tutorial, you will learn how to use autosum in Excel. To perform Autosum, click a nearby cell and click Autosum on the Home tab and press Enter. Autosum adds up a range of numbers automatically and places the result in a nearby cell. Autosum is a very handy tool in Excel to sum cells very fast.