COUNT and SUM by Cell Colour in Excel

Ever found yourself grappling with the challenge of counting or summing cells based on their background fill color in Microsoft Excel? Look no further! In this lesson, we unravel the mysteries without delving into complex VBA code. We understand that not everyone is VBA-savvy, so we've devised a straightforward method using the SUBTOTAL function.

Follow along as we demonstrate how to COUNT and SUM cells with specific background colours using Excel filters. Whether you're identifying students who need to retake a test or analysing sales figures, our step-by-step guide ensures you harness the power of SUBTOTAL with ease. No need to fear the gremlins of VBA—this is the simplest method to achieve quick results and gain insights into your data.

Learning Objectives

• Learn how to efficiently count and sum cells based on their background fill colour in Microsoft Excel using the SUBTOTAL function and filters.