SUM and COUNT by Cell Colour with Secret Excel Function GET.CELL 63




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,…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

3 thoughts on “SUM and COUNT by Cell Colour with Secret Excel Function GET.CELL 63

    Up4Excel

    (January 14, 2020 - 5:23 pm)

    Sum or Count by Cell Colour using the hidden Excel function GET.CELL option 63. Plus….unlock a whole new world of long forgotten Excel Functions using the 2 methods taught in this video. Once you know how to access this function you can SUM, COUNT, AVERAGE, MAX, MIN etc by almost any cell format including Font Size, Font Colour, Font Name and even Row Height.

    Wayne Edmondson

    (January 14, 2020 - 5:23 pm)

    Hi.. interesting.. usually I default to a VBA user defined function to solve something that is not native to the EXCEL workbook/worksheet. I'll have to give these Excel 4 Macro Functions a try. I guess the only downside is if or when Microsoft eliminates them from the base EXCEL code in the future. Thanks for sharing. Thumbs up!

    Mohammed Alfarsi

    (January 14, 2020 - 5:23 pm)

    Hi Sir

    How can I create a password for more than one sheet at the same time?

Leave a Reply

Your email address will not be published. Required fields are marked *