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 Intermediate Excel!
You have completed Intermediate Excel!
Preview
Common Errors
3:30 with Tyler TallonLet's look at some common errors so we can do our best to avoid them.
Downloads
Please note that this is a new spreadsheet, different from the one you used in the previous stage:
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
So for working with this data
that shows sales for cities and
0:00
then sub totals for this four states.
0:03
Now we want to see the grand
total at the bottom,
0:06
it's important to make sure that
you are not double counting.
0:08
So if you type in =SUM, and
then include the entire column,
0:11
you are doubling your total, since
you are including each City sales and
0:18
then also the State totals
which include the City sales.
0:22
So you have two options.
0:26
You can either manually click each
cell that you want to include,
0:28
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