Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Data Analysis Basics!
You have completed Data Analysis Basics!
Preview
In this video we'll use our 10 minute intervals to finish creating our chart!
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
To do this, we're going to use
the count if's function again.
0:00
But first,
0:00
we'll need to copy the range of finishing
times to get it on the clipboard.
0:01
I'll click in here, pick the range of
finishing times and use Cmd or Ctrl+C.
0:06
Then, let's start in this first cell,
by typing =countifs.
0:12
And then, let's paste in
the range of finishing times.
0:19
Next for the first criteria,
let's make sure the finishing time is
0:22
greater than 120 minutes by adding
a greater than sign in quotes.
0:27
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up