Skip to content

Path Playground Leaderboard Blog

fx

ABCD

1

2

3

4

5

Loading…

Free, hands-on Excel practice in a real spreadsheet. Learn by doing, not by watching.

Practice

All exercises
Start with SUM
Learning path
Playground
Keyboard shortcuts
Skills Passport
Leaderboards
Blog

Functions

SUM
IF
XLOOKUP
COUNTIF
All functions

Account

Sign in
Create free account

SheetSkill

About us
Contact us
Privacy Policy
Terms of Use

© 2026 SheetSkill · Learn. Practice. Master. · Always free.Developed by Jerin George Pallath · Not affiliated with Microsoft

PERCENTOF/Top Product Share with SUM

0 of 2394 complete

PERCENTOFIntermediate

Top Product Share with SUM

Question

In cell D9, calculate the share of the highest-selling product (B2) against the total computed with SUM.

Answer in cell D9

How it’s written

=PERCENTOF(data_subset, data_all)

Subset as a share of the total. Arguments in [brackets] are optional.

10 points for a first try without hints, 5 otherwise.

Practice sheetClick the dashed cell D9, type your formula, press Enter.

Loading the spreadsheet…

Check from anywhere with Ctrl + Enter