How to Add Values to Pivot Table in Excel Quickly

To add values to a PivotTable in Excel, drag the desired field into the Values area of the PivotTable Field List. Excel will automatically summarize the data, usually by sum or count, depending on the data type.

Syntax

When working with a PivotTable in Excel, the main parts to add values are:

• PivotTable Field List: The panel where you select fields from your data.
• Values Area: The section where you drag fields to calculate sums, counts, averages, etc.
• Row and Column Areas: Where you place fields to organize data by rows or columns.

Adding a value means dragging a field into the Values area to perform calculations.

text

1. Select your PivotTable.
2. Open the PivotTable Field List.
3. Drag a field (e.g., "Sales") into the Values area.
4. Excel summarizes the data automatically (Sum, Count, etc.).

Example

This example shows how to add the "Sales" field as values in a PivotTable to sum sales by product.

text

Step 1: Select your data range, for example:
Product | Sales
--------|-------
Apple   | 100
Banana  | 150
Apple   | 200
Banana  | 100

Step 2: Insert a PivotTable (Insert > PivotTable).

Step 3: In the PivotTable Field List, drag "Product" to Rows.

Step 4: Drag "Sales" to Values.

Excel will show:
Product | Sum of Sales
--------|--------------
Apple   | 300
Banana  | 250

Output

Product | Sum of Sales
--------|--------------
Apple   | 300
Banana  | 250

Common Pitfalls

• Dragging fields to the wrong area: Putting a numeric field in Rows or Columns instead of Values will not summarize it.
• Wrong summary function: Excel defaults to Sum or Count; you may need to change it by clicking the field in Values and selecting "Value Field Settings".
• Blank or text data: Non-numeric data in the Values area will default to Count, which might be confusing.

text

Wrong way:
- Dragging "Sales" to Rows area shows individual sales entries instead of sums.

Right way:
- Drag "Sales" to Values area to sum sales automatically.

Quick Reference

Action	Description
Drag field to Values	Adds data to be summarized (sum, count, average)
Drag field to Rows	Groups data by rows
Drag field to Columns	Groups data by columns
Change summary type	Right-click value > Value Field Settings > choose Sum, Count, etc.
Refresh PivotTable	Right-click PivotTable > Refresh to update data

Key Takeaways

Drag numeric fields into the Values area to add them to a PivotTable.

Excel summarizes values automatically, usually by sum or count.

Use Value Field Settings to change how values are calculated.

Place fields in Rows or Columns to organize data layout.

Refresh the PivotTable after changing source data to update values.