0 of 62
Basics·Lesson 17 of 62Free

How to calculate a percentage in Google Sheets

Percent of a total

How Percent works

A percent of a total is one value divided by the total. Format the result as a percent with Ctrl+Shift+5 and Sheets shows 0.25 as 25.00%.

part / SUM(range)
Example on this data
=F2/SUM(F2:F4)→0.676… (67.61% as a percent)

The row 2 price as a share of the first three prices.

What you’ll do

You’ll work out what share of all units one order makes up, then show it as a percent. Shares of a total are how you answer “how much of our sales came from this?” at a glance.

Try it

Type =F2/SUM(F2:F4) into K2 and press Enter. Watch what the sheet does.

The result will appear in K2.

K2
New shortcut

Once K2 shows the result, select K2 and press Ctrl+Shift+5 to show it as a percent. It’s Ctrl on a Mac too. (Format as a percent.)

ABCDEFGHIJK
1OrderRepRegionProductUnitsPriceOrder dateShip date
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

The first 18 lessons are free. Pro unlocks the other 44, including a real-world scenario for every section and five closing projects.

See Pro, $49.99 once