The formula simply adds up all the values in C3:C9 (the blue area above) and returns their sum as the value shown in cell C10 (the red area).ĪVERAGE is used to calculate the average of a range of cells–in this case we’ve calculated an average price per item by adding together prices and dividing by the number of items sold. The most basic function is SUM, which sums all values in a range of cells. There are a number of functions in Excel that help you work with numbers and perform calculations. You can use AutoFill to fill sequential numbers, dates, and formulas into cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |