Excel Pivot Table: How to change Count to Sum

Описание: This video will show you how to change the count to sum function in a pivot table.

The count function is basically considered as the default of the pivot table instead of sum. And this is because, when a field is added, there are some rules in the pivot table that decide which calculation to use.

Does the default count function annoy you? You can select a different summary function, wich will automatically be used in the subtotals and grand totals for that field.

After a field has been added to the pivot table, in order to select a different summary function, you can do it in two ways. Follow the clip and you will find the answer.

If you find this useful, please drop a 👍 on the video and subscribe 🧐

Timestamp:
00:00 Intro
00:17 Change the default Count to Sum
01:15 Now, we have Sum of Sales🧐

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...  
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel  
🎥 How to tutorials:    • How to use UPPER in Excel  
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS  

Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel