SOLVED
Home

Calculating percentages

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