In this Excel tutorial we will learn how to SUM and COUNT cells based on the background fill colour of the cell WITHOUT using VBA.

VBA is by far the most flexible way to complete the task BUT, there are other methods we can use if we want a simpler resolution.

The four methods we will explore in this video are:
- Find
- The SUBTOTAL function + Filters
- The AGGREGATE function + Filters
- GET.CELL with a macro

#excel #countbycellcolor #sumbycellcolor #microsoft365

********************************
CREDITS:
GET.CELL method shown in this video:
Original video showing this method by Up4Excel. See original video here ⬇️⬇️
   • Uncover Hidden Excel Powers: Sum & Co...  

GET.CELL full list of arguments posted by user PaddyD on the MrExcel forum. See post here ⬇️⬇️
https://www.mrexcel.com/board/threads....

********************************

🔗LINKS to related videos

🔢5 Ways to COUNT in Excel
   • 🖐️5 Ways to COUNT in Excel – Essentia...  

🧮Get to Grips with COUNTIFS and SUMIFS
   • Get to Grips with COUNTIFS and SUMIFS  

************************************************

🤝Let's CONNECT on social:

➡️TikTok:   / cellmates_  
➡️Instagram:   / cellmatestr.  .
➡️LinkedIn:   / deborahas.  .
➡️Twitter:   / cellmates_  
➡️Facebook:   / cellmates