Data Calculation

Spreadsheet

• Count:

  • COUNTIF: =COUNTIF(range, criteria)
  • COUNTIFS: =COUNTIFS(range1, criteria1,[range2], [criteria2])

• Sum:

  • SUMIF: =SUMIF(range, criteria, [sum_range] )
  • SUMIFS: =SUMIFS(sum_range, range1, criteria1,[range2], [criteria2])

• Average:

  • AVERAGEIF: =AVERAGEIF(range, criteria, [average_range])
  • AVERAGEIFS: =AVERAGEIFS(average_range, range1, criteria1,[range2], [criteria2])

• MAXIFS: =MAXIFS(max_range, range1, criteria1, [range2], [criteria2], ...)

• SUMPRODUCT: =SUMPRODUCT(array1, [array2])