Choose the right calculation

Draft learning material, awaiting human review.

SUM adds numeric values; AVERAGE gives their arithmetic mean. MAX and MIN find the largest and smallest numbers. COUNT counts numeric entries; COUNTA includes text when counting cells that are not empty.

=IF(B2>=80,"Pass","Retry") includes 80 in the passing group. =COUNTIF(D2:D100,"Complete") counts a category. =SUMIF(B2:B20,"North",C2:C20) adds amounts for matching regions. These examples use English function names and comma separators; localized applications may differ.

Use exact matches for unique product or employee codes. Check missing codes and whitespace. IFERROR can handle a known error, but returning zero for every error can disguise an unresolved data problem.

For 6, 8, and 10, the sum is 24, the mean is 8, the minimum is 6, and the maximum is 10.