Excel Magic Trick 480: Percentage Of Total - Formula or PivotTable (Pivot Table)

See how to calculate a percentage of total from a database data set when the variable of interest is text (word) using:
1) COUNTIF, SUM and COUNTA functions in a formula
2)% of Column Total Feature in the Value Field Settings in a Pivot Table (PivotTable)

Basic Statistics in Excel

Category:

Science & Technology

Tags:

• Statistics
• Excel
• Percentage
• Of
• Total
• Formula
• COUNTIF
• SUM
• COUNTA
• functions
• PivotTable
• of
• Column
• Feature
• in
• the
• Value
• Field
• Settings
• Pivot
• Table
• Mike
• Gel
• Girvin
• Busn
• 210
• Highline
• Community
• College

[maflore99]

Thank you very much. Just what i needed. Quick question: why do you need to "lock" or hit the F4 key when you are finding out the percentage? At 2:53

[ExcelIsFun]

The formula would not work if you did not. Try it without it and copy it down and see what it does - then lock it and see what it does. Here is a video all about the different types of Cell references:

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[maflore99]

@ExcelIsFun Oh ok thanks! You're a life saver. Keep these videos coming :)

[ExcelIsFun]

You are welcome!

[error42]

Absolutely appreciate you making this vid. Kudos!

[ExcelIsFun]

You are welcome!

[kalmkrew]

lol zup

[ExcelIsFun]

I do not know how to use a MAC.

You lock the references when you do not want them to move throughout a copy action. It is one of the most fundamental ideas in Excel. See these video title:

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

I have other videos on this topic also, but this is the most comprehensive.

[suenita007]

I'm running into a problem: I tried to hit F4 to lock in the range, but F4 instead worked as a "paste" function. I have a Mac. Is that the issue?

Also, what is the reason for locking the range? Thanks!

[ExcelIsFun]

I just posted a video yesterday on this exact topic. The title is:

Excel Magic Trick 498: 6 PivotTable Calcualtion Tricks (Pivot Table)