In this video, you'll learn three methods to SUM and COUNT cells in Excel based on cell color, as Excel does not have a built-in way to sum by cell color. - **Method 1:** Use the SUBTOTAL function ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change layout.

Conditional formatting in Excel is often associated with basic tasks like highlighting cells based on their values, but its potential goes far beyond these surface-level features. My Online Training ...

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 ...

Q. I receive regular spreadsheets with all of our company’s accounts, departments, employees, and balances, and I have to subtotal the amounts by accounts, departments, etc. I have been manually doing ...