Course contents · Problem book

Sum, count, average

Open the practice in the trainer →

One-function problems: totals over a range and totals by condition.

SUM, AVERAGE, MAX, MIN, COUNTsum, 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".

Tasks in the trainer

  1. In E1 calculate the average temperature over 10 days.
  2. In E2 — the highest temperature.
  3. In E3 — the lowest.
  4. In E4 — the number of days below zero.
  5. In E5 — the sum of the positive temperatures.

Solve the tasks in the trainer →