Average percentages in Excel with a calculated field by Chris Menard

Averaging percentages isn't always straightforward. Often, you will need to use a weighted average. I'll show two examples of when the average percentage is wrong, and then how to calculate the average percentage with a PivotTable using a calculated field.
Add a calculated field
************************
Click inside the PivotTable.
Click on the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.
In the Name box, type a name for the field.
In the Formula box, enter the formula for the field.
Click Add.
************************
Chris Menard's Website: chrismenardtra...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ UA-cam keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@MagicHive]

I was not getting any information about this issue. Thanks. It was to the point.

[@ChrisMenardTraining]

You're welcome

[@pambansangjo4467]

I appreciate this video. Thanks for the info

[@ChrisMenardTraining]

Glad it was helpful!

[@anandkrishvvenkat5644]

Hey Chris,
Thank you so much. I understood within 2 to 3 mins which is correct and which is not ?

[@ChrisMenardTraining]

Thank you.

[@moumitagupta8124]

is the formula of Percentage for making a marksheet in ms Excel is same as average?

[@akervan27]

Thanks!

[@ChrisMenardTraining]

Welcome!

[@SubinGeorge26]

@07:20 When you right-clicked, in the drop-down menu, "Summarize Values By" option is greyed out. Why is that sir? I am looking for a way to get the average out of a calculated field but I'm out of luck so far.

[@SubinGeorge26]

Going to the value field settings isn't helping either. It always returns a sum.
I'm forced to create a new column in the source data to get what I need.

[@ashviksahay1532]

Good job bro be a good mathematician

[@ChrisMenardTraining]

Ashvik, thank you.

[@blairjackman5717]

I mean... Trix are for kids, so...
(jk very helpful, thank you!)

[@ChrisMenardTraining]

Silly rabbit! Thank you.