To clearly illustrate your point, it's usually best to represent it visually. Excel makes this quick and easy with data bars.
There is a way to see a total without adding a formula or subtotal to your worksheet.
If you have ever taken a look at a formula in Excel, they can be very intimidating. But here's a way to think about formulas that will make them easier to understand.