# Pivot table basic sum

Pivot tables make it easy to quickly sum values in various ways. In the example shown, a pivot table is used to sum amounts by color.

### Fields

The pivot table shown is based on two fields: **Color** and **Amount**. The **Color** field is configured as a row field, and the **Amount** field is a value field, as seen below:

The Amount field is configured to Sum:

You are free to rename "Sum of Name" as you like.

### Steps

- Create a pivot table
- Add a category field the rows area (optional)
- Add field to count to Values area
- Change value field settings to show sum if needed

### Notes

- When numeric field is added as a Value field, Excel will display a sum automatically.
- Without a Row field, the sum will be the total of all Amounts.

## Pivot Table Training

If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. Core Pivot is a step-by-step Excel video course that will teach you everything you need to know to use this powerful tool. With a small investment, Pivot Tables will pay you back again and again. See details here.