SUM and COUNT by Cell Colour in Excel WITHOUT VBA

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Lt3p2zl1l10

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

#############################

New on site