autosum

autosum

A function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. It sets the range of cells by looking for numeric data above the selected cell.


The Autosum Function
After selecting the cell to the right of Total Monthly and clicking the autosum icon (red arrow is pointing to it), the range from F3 to F9 is automatically determined by the program.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
The AutoSum command in Excel usually enters a SUM function for the adjacent data set.
If you wish to find the average age of members, the data captured in a "How old are you?" question can be exported to Excel, and the software's 'AutoSum" feature will generate the average age in a matter of seconds.
Other highlights are an Autosum feature, 75 built-in functions, mail merge, endnotes and more.
Rather than dealing with pivot tables and VLOOKUP, I was answering questions about the name for the intersection of a row and column, plus far too many simple questions about using AutoSum.
Can you imagine 300 million potential job applicants who will swear they use Excel who have never even clicked the AutoSum button?
* Excel: To easily add noncontiguous numbers, place your cursor in the cell you want the sum to appear, click on AutoSum ([SIGMA]), and while you're holding down the Ctrl key click on each of the cells you want to include.
The Secret Life of the AutoSum Icon: Ad Hoc Totals of Filtered Records
Regular Excel users are familiar with the AutoSum button, the Greek letter Sigma icon in the toolbar.
* Mouse: Place your cursor on B13 (one cell below the column you are adding) and click on the AutoSum icon: [[summation of]], producing this screen (notice the shortcut actually generates the same full formula):
I know I can add a column of numbers by writing a formula such as =sum(A1+A12, or by clicking on AutoSum ([SIGMA]).
* Excel's AutoSum [AutoSum] automatically enters the sum of any column or row of values.