To have text values considered as 0 values, use AVERAGEA.ĪVERAGE returns the mean of the combined value arguments that is, the sum of the values in the value arguments divided by the number of such values. Additional values or ranges to consider when calculating the average value.Īlthough AVERAGE is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.Īny text encountered in the value arguments will be ignored. Value1 - The first value or range to consider when calculating the average value. The AVERAGE function returns the numerical average value in a dataset, ignoring text.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |