How to SUM & COUNT Cells By Color in Excel

How to SUM and COUNT cells based on color in Excel. 🚀 FREE 50 Excel Hacks Template from Hubspot: https://clickhubspot.com/43bbfd 🆓 DOWNLOAD Free Excel file & Code for this video: https://careerprinciples.myflodesk.co... In this video I'll teach 3 ways to SUM and COUNT cells in Excel based on color. By default, Excel doesn't have a built-in way to do sum by cell color. The first method is to use the SUBTOTAL function and the filter by color feature. The SUBTOTAL allows us to find the SUM, COUNT, AVERAGE, and more. The only problem with this is that we can't see all the data, and we can only see one total at once. The second method is using the name manager, where we can use the GET.CELL feature to find the background cell color. With this information, we can use the SUMIF and COUNTIF to find the COUNT and SUM by cell color. The main problem with this is that it's quite tedious to set up and doesn't update automatically. So the third and superior method is to use VBA to COUNT and SUM by cell color. We'll set up 2 custom functions (one for count, one for sum) so we can easily calculate this. To refresh the data, we'll create a macro and assign it to a button. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour... 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/cour... 🚀 All our courses: https://www.careerprinciples.com/all-... ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Method 1: Easy & Manual 3:00​ - Method 2: Intermediate & Semi-Automated 7:11​ - Method 3: Advanced & Fully Automated