SOLVED
Home

Calculating percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-360658%22%20slang%3D%22en-US%22%3ECalculating%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360658%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20this%20is%20a%20very%20simple%20answer%2C%20I%20just%20cant%20figure%20it%20out.%20I%20need%20to%20know%20how%20to%20make%20a%20column%20show%20percentages%20of%20the%20adjacent%20columns%20figure%20to%20a%20specific%20cell.%20For%20example%3B%20The%20single%20cell%20shows%20total%20sales%20figure%2C%20and%20the%20column%20shows%20expenses%20by%20category.%20How%20do%20I%20make%20a%20column%20next%20to%20expenses%20that%20show%20their%20percentage%20of%20total%20sales%20without%20having%20to%20change%20the%20formula%20in%20each%20cell%20in%20the%20column%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360674%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360674%22%20slang%3D%22en-US%22%3ERemember%20this%20tip%3A%3CBR%20%2F%3EIf%20you%20copy%20the%20formula%20down%20rows%2C%20lock%20the%20row%20by%20inserting%20a%20dollar%20(%24)%20sign%20before%20the%20row%20number.%3CBR%20%2F%3EConversely%2C%20lock%20the%20column%20by%20inserting%20a%20dollar%20(%24)%20sign%20before%20the%20column%20number%2C%20if%20you%20copy%20across%20columns.%3CBR%20%2F%3ESuccinctly%20stated%3A%3CBR%20%2F%3ECopy%20down%20rows%3F%20Lock%20row%20number%3CBR%20%2F%3ECopy%20across%20columns%3F%20Lock%20column%20letter%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360666%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360666%22%20slang%3D%22en-US%22%3E%3CP%3EAwesome%2C%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360664%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360664%22%20slang%3D%22en-US%22%3EUse%20absolute%20row%20reference%20for%20the%20total%20sales.%20If%20your%20expenses%20are%20in%20A2%3AA9%20and%20your%20total%20sales%20in%20D1%2C%20your%20formula%20in%20B2%2C%20copied%20down%20to%20B9%20is%3A%3CBR%20%2F%3E%3DA2%2FD%241%3CBR%20%2F%3EFormat%20B2%3AB9%20as%20Percentage.%3C%2FLINGO-BODY%3E
Highlighted
ram58072420
New Contributor

I'm sure this is a very simple answer, I just cant figure it out. I need to know how to make a column show percentages of the adjacent columns figure to a specific cell. For example; The single cell shows total sales figure, and the column shows expenses by category. How do I make a column next to expenses that show their percentage of total sales without having to change the formula in each cell in the column?

3 Replies
Solution
Use absolute row reference for the total sales. If your expenses are in A2:A9 and your total sales in D1, your formula in B2, copied down to B9 is:
=A2/D$1
Format B2:B9 as Percentage.

Awesome, Thanks!

Remember this tip:
If you copy the formula down rows, lock the row by inserting a dollar ($) sign before the row number.
Conversely, lock the column by inserting a dollar ($) sign before the column number, if you copy across columns.
Succinctly stated:
Copy down rows? Lock row number
Copy across columns? Lock column letter
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies