Menu

1 / 4

Excel has a better way to calculate percentages, and I've been doing it the hard way

#makeuseof#div#total#column#percentof
Reading 0:00
15s threshold

Published Nov 15, 2026, 3:00 PM EST

Jonathon Jachura is a mechanical engineer with over 12 years of HVAC industry experience who specializes in translating complex home systems into practical advice for everyday homeowners. His background spans technical sales and product management for major manufacturers, combined with hands-on experience as a two-time homeowner who has tackled everything from system installations to troubleshooting repairs. Jon focuses on helping readers make confident decisions about their homes through clear, actionable guidance that saves both time and money.

I use Excel to track the budget for our household expenses. My spreadsheet lists each expense category, with a column where I show what percentage of the budget that category represents. That column divides each category by a total row, with dollar signs locking the reference every time.

The percentage column is the one I actually watch.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.