if the code below the function looks for the value of C17 in the range C3:C14
if the value matches the corresponding value in column is is added to the sum
=SUMIF(<range to sum>,<value to search for>,<for each match found what range to find the value to add to the sum >)
=SUMIF(C3:C14,C17,D3:D4)
SUMIF with a value arg
=SUMIF(D118:D122,">50")
the code below searches two different ranges in order usng different criteria for
each range
=SUMIFS(<range to sum>,<first range to look for matches>,<criteria for first match>,<second range to look for matches>,<criteria for second match>)
COUNTIF and COUNTIFS functions only take a range and criteria
count is incremented when a cell in the range matches the criteria
similar rpototypes to SUMIF and SUMIFS
=COUNTIF(<range to search>,<value to search for>)
=COUNTIFS(<first range to look for matches>,<criteria for first match>,<second range to look for matches>,<criteria for second match>)
AVERAGEIF and AVERAGEIFS
=AVERAGEIF(<range to search>,<value to search for>,<for each match found what range to find the value to be added for averaging>)
=AVERAGEIFS(<range to search>,<first range to look for matches>,<criteria for first match>,<second range to look for matches>,<criteria for second match>)
MAXIFS
=MAXIFS(<range to search>,<first range to look for matches>,<criteria for first match>,<second range to look for matches>,<criteria for second match>)
MINIFS
=MINIFS(<range to search>,<first range to look for matches>,<criteria for first match>,<second range to look for matches>,<criteria for second match>)