Pinterest Pixel

Change Count to Sum in Excel Pivot Tables

SUM is an important function displayed in the Pivot Table. Let’s see how we can change COUNT... read more

Download Excel Workbook
Bryan
Posted on

Overview

Change Count to Sum in Excel Pivot Tables | MyExcelOnline Change Count to Sum in Excel Pivot Tables | MyExcelOnline

SUM is an important function displayed in the Pivot Table. Let’s see how we can change COUNT to SUM in Pivot Table.

By default, when you put any field into the VALUES area of the pivot table it counts and displays the sum of the values. However, a much more common and needed function is the sum of the values of the field.

So let us see how we can change the COUNT to SUM in a Pivot Table.

 

Exercise Workbook:

download excel workbookChange-Count-of-to-Sum-of.xlsx


Here is our Pivot Table, it’s currently set up to get the counts. But we want the sum of sales instead, so let us fix that pronto!

Change Count to Sum in Excel Pivot Tables

Method 1: Using the Pivot Table Fields tab.

STEP 1: Click on the arrow beside Count of SALES and select Value Field Settings

Change Count to Sum in Excel Pivot Tables

STEP 2: Select Sum and click OK

Change Count to Sum in Excel Pivot Tables

Now your Sales values are now being calculated as Sum instead of Count!

See also  Pivot Chart Settings

Change Count to Sum in Excel Pivot Tables

Method 2: Directly through the Pivot Table cells.

Additionally, you can also try this approach:

Step 1: Select any cell within the column.

Change Count to Sum in Excel Pivot Tables

Step 2: Right-click the cell and select Summarize Values By Sum from the drop-down menu.

Change Count to Sum in Excel Pivot Tables

As you can see, the field value has now been updated to SUM instead of COUNT.

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Change Count to Sum in Excel Pivot Tables | MyExcelOnline Change Count to Sum in Excel Pivot Tables | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...