COUNTIFS function

2. Download your dataset

1:  Right click on the file below to save a copy of the dataset for Part 2 of this module containing data from the 2016 Health and Society Health Survey in Excel format.  You should select the "save as ..." option, and save the file to your flash drive:

2016 Health and Society Student Health Survey data

 

2:  Open your Excel dataset (workbook)

The workbook has several worksheets, including "data", "metadata", "calculations", "summary table", and "graph".  

Your "calculations" worksheet is blank - the tables you will need to enter your calculations have not been pre-formatted for you.  This will give you more practice in creating/formatting your own tables in Excel.