If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done.

To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.

Use the SUBTOTAL function to count the number of values in an Excel table or range of cells. If the table or range contains hidden cells, you can use SUBTOTAL to include or exclude those hidden cells, and this is the biggest difference between SUM and SUBTOTAL functions.

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.)

Add the values in a range by using the Sum function in a formula (ranges meaning more than one group of cells).

Add numbers using cell references A cell reference combines the column letter and row number, such as A1 or F345. When you use cell references in a formula instead of the cell value, you can change the value without having to change the formula. Type a number, such as 5, in cell C1. Then type another number, such as 3, in D1.

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear. On the Formulas tab, click More Functions, point to Statistical, and then select one of the following functions: COUNTA: To count cells that are not empty

When you enter a value in cell B2 (the first argument), VLOOKUP searches the cells in the range C2:E7 (2nd argument) and returns the closest approximate match from the third column in the range, column E (3rd argument).