Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest ...

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

Excel Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest ...

Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

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.

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.

The SUBTOTAL Function Microsoft Excel's SUBTOTAL function is quite simple to use. It lets you perform subtotal calculations for ranges of cells, and you can decide whether you want to include ...

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.