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

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code. Editor’s Note: This article was originally ...