How to Count and Add by Cell Color Without VBA in Excel

Опубликовано: 10 Май 2026
на канале: Excel Formation

3,246

149

❤️ Subscribe to the channel: https://bit.ly/31xepIW

💻 ARTICLE AND DOWNLOAD LINK: https://www.excelformation.fr/add-acc...

DISCOVER THE TOOLBAR BY EXCELFORMATION.FR: https://www.excelformation.fr/barre-o...

🗨️ In this tutorial, I'll show you how to automatically count and add cells based on their background color, without needing to create complicated VBA macros.
To do this, we'll use a secret Excel 4.0 function that still works perfectly today.
This technique will save you a considerable amount of time if you use color codes to organize your data.

😻 If you like this video, I strongly encourage you to like it and subscribe to the channel. This will allow me to grow my channel, so I can continue to offer you content like this!
📢 Also, ask me any #Excel questions you may have in the comments section; I'll be happy to answer them!

============================================

📚 #Exceltraining:
❤️ The best tips for #Excel beginners and pros (FREE) ❤️ : https://www.excelformation.fr/astuces...
❤️ Training: Excel Basics (For Complete Beginners) ❤️ : https://www.excelformation.fr/formati...
❤️ Training: Mastering Excel (Intermediate) ❤️ : https://www.excelformation.fr/formati...
❤️ Training: Regain control of your data with DBT ❤️ : https://www.excelformation.fr/formati...
❤️ eBook: VBA for Complete Beginners ❤️ : https://www.excelformation.fr/formati...

=================================================

❓ USEFUL LINKS:
The SUMIF() function = https://www.excelformation.fr/la-fonc...
Learn VBA for beginners = https://www.excelformation.fr/formati...
Training - Take control of your data with Excel's pivot tables = https://www.excelformation.fr/formati...
L'ENCODEUR – The ultimate protection for your data! = www.excelformation.fr/lencodeur.html
SAVEMYFILES – How to never lose data in Excel again? = https://www.excelformation.fr/savemyf...

=================================================

👨‍👨‍👧‍👦 Social Media:
Facebook:   / excelformation.fr
Twitter:   / excelformation
Instagram:   / excelformation.fr