One-function problems: totals over a range and totals by condition.
SUM, AVERAGE, MAX, MIN, COUNT | sum, average, maximum, minimum, count of numbers |
COUNTIF(range, criteria) | how many values meet a condition |
SUMIF(range, criteria) | sum of the values that meet a condition |
Write the condition in quotes: "<0", ">=5", "<>0".