![]() The formula uses the AVERAGE function to average the cells containing numbers and ignores the empty cells or those containing text.įor more information about the AVERAGE function, see the course summary at the end of the course. To average values in cells and ranges of cells that aren't adjacent, type an equals sign (a formula always starts with an equals sign), AVERAGE, open parenthesis, hold down the Ctrl key, click the desired cells and ranges of cells, and press Enter. to visually show how cell values in a range are compared to each other. If C4 contained a number, C2 through C5 would be an adjacent range of cells that AutoSum would recognize. Icon Sets in Excel are ready-to-use formatting options that add various icons to cells, such as arrows, shapes, check marks, flags, rating starts, etc. If I try to use the AutoSum, Average option here, it only uses cell C5, not the entire column. With larger ranges of cells, it's essential. ![]() When averaging a few cells, the AVERAGE function saves your time. The formula is AVERAGE, A2, colon, A5, which averages the cells from A2 through A5. Pressing the Up, Down, Left, or Right arrow key will move the active cell in the. When I double-click inside the cell, I see it is a formula with the AVERAGE function. The simplest way to select a single cell is to use the arrow keys. ![]() Then, on the HOME tab, click the AutoSum down arrow, click Average, verify the formula if what you want, and press Enter. You may have used AutoSum to quickly add numbers in Excel.īut did you know you can also use it to calculate other results, such as averages?Ĭlick the cell to the right of a row or below a column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |