SUM and COUNT by Cell Colour in Excel -- WITHOUT VBA!

Great thanks

Hi , thank you for this interesting video, I'm trying to do it with Sumif, but not working. what would be the formula?

Interesting solutions and workaround Deb.

Great video Deb. 👍

A little warning about the GET.CELL method.

I believe the workbook needs to be saved as .a xlsm file type. Which means other users will need to unblock or enable the file before it will operate correctly.

GET.CELL is an Excel 4 Macro and it is no longer supported. So Microsoft could remove the functionality without any warning if they wanted to (unlikely, but possible).

It's an eyedropper what you're looking for. Thanks for the video.

Nice to see you again.