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
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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies