2. Determine the formulas you need for your sheet. In our example, we want to get the total number of items sold, Total Sales for each item, Grand Total Sales, and the Quota Classification.