Excel functions in plain English
Browse function explanations, sentence patterns, examples, and links to customise a query. Page 1 of 6.
Adds numbers.
Read sentence and examples ↗Adds values that meet one condition.
Read sentence and examples ↗Adds values that meet multiple conditions.
Read sentence and examples ↗Counts cells containing numbers.
Read sentence and examples ↗Counts non-empty cells.
Read sentence and examples ↗Counts blank cells.
Read sentence and examples ↗Counts cells matching one condition.
Read sentence and examples ↗Counts cells or rows matching multiple conditions.
Read sentence and examples ↗Calculates the arithmetic mean.
Read sentence and examples ↗Averages values that meet one condition.
Read sentence and examples ↗Averages values that meet multiple conditions.
Read sentence and examples ↗Returns the largest value.
Read sentence and examples ↗Returns the smallest value.
Read sentence and examples ↗Returns the largest value meeting conditions.
Read sentence and examples ↗Returns the smallest value meeting conditions.
Read sentence and examples ↗Returns the middle value.
Read sentence and examples ↗Returns the most frequently occurring value.
Read sentence and examples ↗Returns the k-th largest value.
Read sentence and examples ↗Returns the k-th smallest value.
Read sentence and examples ↗Rounds a number to a given number of digits.
Read sentence and examples ↗