![]() In order to calculate the average of non-contiguous (non-adjacent) cells, simply hold the Control key (or Command key - Mac users) while making the selections. This can be typed directly into the cell or formula bar, or selected on the worksheet by selecting the first cell in the range, and dragging the mouse to the last cell in the range. To calculate the average of values in cells B2, B3, B4, and B5 enter: = AVERAGE ( B2 : B5 ) The formula below will calculate the average of the numbers 100, 95, and 80. Only one argument is required, but of course, if you’re using the AVERAGE function, it’s likely you have at least two. The AVERAGE function can handle up to 255 arguments, each of which may be a value, cell reference, or range. ![]() ![]() Ranges or cell references may be used instead of explicit values. The AVERAGE function in Excel is straightforward. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |