Back to Component 2
Do it now
Spot the graph errors
This graph has 4 mistakes. Click a dashed box. Then pick the best fix.
Fixed: 0 of 4
Click a dashed box
Take your time. There is no timer and no score.
Make a graph with COUNTIF
We will count how many bookings gave each rating, then make a column chart. One step at a time.
Step 1 of 10
Formula bar:
The whole formula is:
=COUNTIF(Dataset!J3:J52,1)You type it in 3 small parts. Steps 4, 5 and 6 each add one part.