Excel Pivot Table: How To Sum Two Columns

In this quick and easy tutorial, learn how to sum two columns using Excel's Pivot Table feature.

We'll walk you through the entire process, from setting up your Pivot Table to adding your columns and calculating their sum.

Discover how to add two columns together in Excel using Pivot Tables with this simple tutorial. Perfect for Excel beginners or anyone needing a quick refresher!

👉 Step 1: Prepare Your Data & Create a Pivot Table

👉 Step 2: Sum Two Columns
Navigate to the "Pivot Table Analyze" tab, find “Fields, Items & Sets,” and choose "Calculated Field." Here, you can create a new field using a formula to sum your desired columns. For instance, if you want to add Column A and Column B, you would write: ColumnA + ColumnB.

👉 Step 3: You’re Done!
Your new calculated field will now appear in your Pivot Table, displaying the sum of your two chosen columns.

That’s it – quick and easy! Your two columns are now summed up in a new field within your Pivot Table. Experiment with different columns and formulas to get the most out of your data.

💡 Need Help or More Tips?
Got questions? Need more help? Just leave a comment below!

Timestamp:
00:00 Intro
00:05 Setting up Your Pivot Table
00:21 Adding Columns and Calculating Sum
01:20 Conclusion

🔴 RECOMMENDED VIDEOS/PLAYLISTS

[cogwheelLearning]

Problem solved? The next thing on your to do list is smashing the thumbs up button

[stevenlitvintchouk]

Perfect! This is exactly what I was looking for.

[ktcolo]

Thanks - that is a feature I was not aware of. It would be nice to be able to only show the total column in the pivot without the other two columns

[xuyenle]

Hi, thanks for sharing. Could you please guide me how to sum two or more columns in pivot table when they are part of pivot table but not part of the data source? I hope my question is clear enough. But if not, pls let me know to provide you with more details. Thank you