command in Excel usually enters a SUM function for the adjacent data set.
I used the AutoSum
function to get this information.
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
* Excel's AutoSum
[AutoSum] automatically enters the sum of any column or row of values.