If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

Other benefits to using SUBTOTAL are that you can opt to ignore any numbers that have been hidden, dynamically summarize data, and sum filtered values. And one of the most useful reasons is that you ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.