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 WORKBOOK


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 | MyExcelOnline

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 | MyExcelOnline

STEP 2: Select Sum and click OK

Change Count to Sum in Excel Pivot Tables | MyExcelOnline

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

Change Count to Sum

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 | MyExcelOnline

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 | MyExcelOnline

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

 

HELPFUL RESOURCE:

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

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Linkedin