Harness the power of Subtotal in Excel to count grouped items Your email has been sent Excel's Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows ...

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. When you try to copy the subtotals by themselves, ...

If you have three or more rows of data, chances are, you'll need to summarize those values in some way. Summarizing is one of the most common tasks we perform in Excel. The term summarize implies a ...

Excel is one of those tools that we all know and use, but let’s be honest—most of us barely scratch the surface of its true potential. Sure, you’ve probably mastered the basics like SUM or AVERAGE, ...

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria. Filters are a ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

For productivity software, Microsoft Office is not the only game in town. You can download a free copy of OpenOffice and get equivalent programs: a word processor ...

Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know Excel ...