You can produce the same results with one click as follows: To sum monthly and personnel values using the above methods requires at least two clicks to AutoSum. There's more to AutoSum than this though! Expanding on range Selecting a row or a column of values plus the appropriate adjacent cells to sum the selected values.Selecting an adjacent cell or a range of adjacent cells to sum contiguous values.This is the extent to which most users apply AutoSum: Similarly, if you select C15:G15, AutoSum inserts a row of personnel totals, as shown in Figure C. The result is a column of monthly totals in column G.
Using our example data set, you could select G3:G14 and click AutoSum. Simply select an adjacent range of blank cells. Usually, you work with more than a single row or column, and fortunately, AutoSum adapts well to multiple rows and columns. Figure B You can select values and an adjacent blank cell. For instance, you might select C12:C15 to return the total for the last quarter of the year. Selecting the values and a blank adjacent cell has the advantage of letting you choose the values you want to evaluate when you don't want to include every contiguous value. Again, Excel stops including cells when it encounters a non-numeric value, and it knows to insert the function in the adjacent blank cell. Similarly, if you select C3:C15, Excel will insert the appropriate SUM() function for Smith in C15. For example, selecting C3:G3 and clicking AutoSum will insert the same SUM() function, as shown in Figure B. You can also select a row or column of values and the adjacent blank cell. SEE: How to use built-in Excel features to find duplicates In both cases, there's no need to manually type the function or the cell references AutoSum does everything. To the right in Figure A, AutoSum entered a SUM() function that references the values in column C-Smith's values. The feature works similarly on columns of contiguous values. (You can also press +=.) Figure A Sum a single row or column of contiguous values.Įxcel knows that the value in B3 is text and stops looking for values to evaluate. For example, if you select G3 ( Figure A) and then click AutoSum and press Enter, Excel will enter a SUM() function that references C3:F3-January's values. Most everyone knows that you can click a blank cell adjacent to a row or column of values and that AutoSum will total those contiguous values.
AutoSum is available in 365's browser version, but it's limited because you can't build multiple-range selections. I'm using Excel 2016 on a Windows 10 64-bit system, but most of these techniques will work in earlier versions. Excel is still a security headache after 30 years because of this one feature.How to see who is trying to break into your Office 365 and what they're trying to hack.Microsoft reveals pricing and other details for Office 2021.
0 kommentar(er)
