Excel Study · Module 1: First steps
Class 8Percentage of total
Basics1:50 videoFree
What share of the total did each product bring in? Divide each value by the total and lock the total with F4: =B2/$B$7.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, product sales are in B2 to B6 and the total sales figure is in B7. I want each product's share of the total in column C, starting in C2. Write the formula for C2 that I can copy down to C6.
The answer that works
✓ checked in Excel=B2/$B$7
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.