Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Spreadsheet Basics

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

The COUNT Function

1:02 with Michael Watson

The COUNT function lets you determine how many numbers are in a group of cells. It only counts the cells that actually contain a number, so empty cells (or cells with text) are ignored in the count.

Example Files

  • you can continue to use the spreadsheet from the last video, or
  • open a copy of this spreadsheet to catch up to this video

Reference

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    The count function will tell you how many cells you have selected. 0:00
    It does not sum up the numbers. 0:03
    It tells you how many there are. 0:05
    Sometimes you may have a group of cells that contain numerical and text values. 0:07
    Here we're looking at a sheet that has months and 0:12
    the total number of transacted sales that occurred in that month. 0:15
    Let's look at count in the context of this spreadsheet. 0:18
    So, I'm selecting, All 12 months, and it returns back 12. 0:23
    It's not the sum or the total of all the sales that occurred over the year. 0:32
    It's the number of cells that have been selected. 0:36
    This is a simple example. 0:39
    But notice that if I change this formula so 0:41
    that it selects column A as well, the value doesn't change. 0:44
    That's because even though there's 24 cells that have been selected, 0:49
    it shows 12 because there's only 12 cells with numbers. 0:54
    Sometimes I use count to spot check that I've selected the right amount of columns 0:57
    or rows. 1:00

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up