For example, if you want to add the values in cells A1, A2, and A3, type the below and hit Enter. =A1+A2+A3 Excel also lets you combine direct numbers and cell references in the same formula.

Just move your cursor to the bottom of your table and enter a new record on the next available row; for example, enter Snowbird on row 17 and Alta on row 18. Excel formats the style as you type.

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.