So, please ensure that all cells within the COUNT, SUM and AVERAGE formula are all formatted as Number, not Text. E2:E16 in this example) not in the number format will be ignored. Any record within the formula range (i.e. Lastly, to find out the average sales that we made for all phones, we can use the AVERAGE formula as below: =AVERAGE(E2:E16)ĬOUNT, SUM and AVERAGE formulas will only work for records where the cell value is in number format.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |