CellReps
Practice
Progress
Sign in
Conditional totals
Conditional totals
SUMIFS, COUNTIFS, AVERAGEIFS ·
0
of 4 solved
Total sales for one region and one category with SUMIFS
Level 2
Count students at or above a pass mark held in a cell
Level 2
Average order value for one channel and country, rounded
Level 3
Sum sales between a start date and an end date held in cells
Level 4