About this tutorial:
Video duration: 9:36
📗 Download This Video Workbook: »»
SUM or COUNT by cell colour using the hidden Excel function GET.CELL – Just one of the 66 operations this function can perform. Unlock a whole new world of long forgotten Excel Functions using the 2 methods taught in this video.
👨🏫 Remove On-Screen Tutor: »» Coming on 31st Jan 2020
=GET.CELL(63,[A1]) detects the fill colour of any cell….but it doesn’t work on a modern Excel sheet unless you apply one of the techniques in this video.
Once you know how to access this function you can SUM, COUNT, AVERAGE, MAX,…