Conditional Counting and Totals1/5
Spreadsheet practice
Complete each goal to unlock the next task.
Module progress0/5
Goal
Count items with sold values at least 20.
COUNTIF counts cells that meet one condition.
Steps
- 1Use the sold range.
- 2Set the condition to include values of 20 or more.
- 3Type = to start a formula.
- 4Use COUNTIF for this task.
- 5Use the worksheet labels to identify the correct range, criteria, lookup table, or return column.
- 6Press Enter and check the result.
0 points
Spreadsheet workspace
Loading spreadsheet engine...