Apply functions in formulas by performing logical operations including AND, OR, NOT, and nested functions and statistical operations including SUMIFS, AVERAGEIFS, and COUNTIFS functions in spreadsheet software.g SUMIFS, AVERAGEIFS, and COUNTIFS functions in spreadsheet software.
