Excel Forum

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

Got a Question? Ask it Here in the Forum.