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

[@pixelmasque]

my fav lady/excel teacher Voice.

[@GeorgiaEBinns]

Thank you! Great help!

[@jbyrd6730]

I stumbled upon your video and I must say this is a game changer for me…especially the calculate now button! Thank you so much!!!

[@cellmatestraining]

@@jbyrd6730 you’re welcome!

[@GrainneDuggan_Excel]

Interesting solutions and workaround Deb.

[@godofthecorn3011]

Question for you! If I have cells of a specific color that are in bultiple different rows and different columns, will this still work? or does it need to be a nice and neat column like your example in the video?

[@Mr3213215]

Nice to see you again.

[@cellmatestraining]

Thanks! It’s been a while!

[@RFHewitt22]

Brilliant! Thank you!

[@charlesxix]

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

[@cellmatestraining]

Haha my brain blanked on eye dropper and all I could remember was a pipette! 😂

[@ExcelOffTheGrid]

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).

[@cellmatestraining]

Yep it needs to be saved as a macro enabled spreadsheet! Good knowledge, thanks for the tip Mark! :)

[@miladyacoub8013]

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

[@cellmatestraining]

Hello, you can't do it with SUMIF which is why I haven't shown that method in the video

[@Noob-ng1of]

Badass channel name.

[@cellmatestraining]

@@Noob-ng1of haha! Thanks!

[@mzportr]

Thank you for this wonderful video. Is it possible to SUM by cell color using the "Get.Cell" command?

[@kanikabhatia4705]

can you provide commands for macbooks?

[@sajjadabouei6721]

thank you , it was really helpful

[@marktaylor299]

Hi. Loving your tutorials Deb. I have a spreadsheet with coloured cells and values- to identify how much is being spent on each person for Christmas 🎄!! Each colour represents a different person. Can these values be filtered by colour and the values totalled- so at a glance one can see the totals for each person? Many thanks Mark

[@harmony1547]

Hello, I keep getting #NAME? when i do the +now0+0, is there anyway to fix this?

[@mamamtl]

Are you putting open and close brackets =now() ?

[@hakkimabdula]

Great thanks

[@ges05]

Is it possible to do it by the color of the text in cell?

[@UltimateKeo]

the subtotal function just says 0 for me when i select my range

[@svpst1]

Hey Deb, did you leave Simon or is this just just a side hustle?

[@cellmatestraining]

Hello, I'm a freelancer. I don't work for SimonSez IT but I do freelance work for them as well as many other clients.

[@mamamtl]

You can use Subtotal with 100 plus the function (eg. 102 =count) to ignore hidden. Instead of aggregate.

[@shefaliaggarwal7201]

Hlo mam I have using vba code but my excel file is very slow while working on it

[@vannyr6114]

I get the same "name" error

[@gabech84]

but how do you sum by colour?

[@cellmatestraining]

There’s an annotation in the video. Method is the same. Use SUBTOTAL or AGGREGATE but select SUM from the list instead of COUNT.

[@nidhiG999]

Too much talking...first 5min were a complete waste.....Just jump to the main stuff

[@jalins6]

This video is only for people who are proficient with excel. It’s not for the massive amount of people who are not. If views are important to you, you should make it for people who have never used excel or almost never use it, which is almost everyone. For that matter, you should make EVERY video from that point of view.

[@cellmatestraining]

Hello, I complete disagree with you. Not every video is for everyone. I post a complete mix of very basic to more advanced videos. This video ISN’T aimed at those with zero knowledge of Excel. All of my videos are tagged Basic, Intermediate or Advanced. You can see it in the thumbnail. This one says ‘Excel Advanced’ in the corner. Not every video can start with a recap of the most basic concepts. If views on KZbin were that important to me, I’d post more than 1 video a month. 🤣 If you are looking to learn Excel from scratch, I would suggest a Beginners training course that moves logically through the content. Thanks!

[@zZMaDsKILLSZz-1]

I agree with @cellmatestraining as well, but to add on Excel as a program could be greatly updated with User Functionality. These ARE the easiest solutions to this problem right now, and the only viable ones @jalins6 take your issue up with Microsoft

[@andywright8495]

I also disagree with you. Little hints and tips are just as important in order to improve productivity.