Excel: Sumif Function

Excel: Sumif Function

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

SharePoint: YEAR function

SharePoint: YEAR function

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