Excel: Sum Function

Excel: Sum Function

Adds numbers, cells, or ranges into a single total. A single error in the range takes over the result.

SharePoint: UPPER function

SharePoint: UPPER function

Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.

Excel: Count Function

Excel: Count Function

Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.

Power Apps: LookUp Function

Power Apps: LookUp Function

Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.