Here are three ways to count the different colors in a range in Excel.

Currently there is no normal way to do this. We'll look at three ways which include a Filter, Name Manager, and then VBA.

Timestamps:
00:00 Introduction
00:18 Way 1 - Using Filter
01:10 Way 2 - Using Name Manager
03:32 Way 3 - Creating a Formula with VBA


Get 52 Project TOOL Templates ready-made and ready to use here: https://www.etsy.com/listing/1199800561/50-project-management-templates-in-excel

Get my PMP Prep Course (35 PDUs) here: https://www.udemy.com/course/ultimate-project-management-pmp-35-pdus/?referralCode=304F47999BDAF3A4BEBE