Excel: Sumif Function

Excel: Sumif Function

Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.

Excel: Countif Function

Excel: Countif Function

Counts the cells in a range that meet one condition. Text matching ignores case.

SharePoint: YEAR function

SharePoint: YEAR function

Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.