How to get a desired total quickly via pivot table

Reports
1

  1. Select cell A1.

  2. Click Data -> PivotTable…

  3. Click OK

  4. A new tab opens. In the dialog box that appears on the right, find the column you want totaled. Click the check box.

Your total will be in the table on the left. Repeat as needed for each desired total.

Note that if you choose your column order for the report to have things you want totaled listed first, step 4 will be very fast.