Grab the file I used in the video from here 👉 pages.xelplus.com/sum-color-file

it is just not what you teach, it is also how you present the knowledge to in front of us. I admire your way of teaching. I am only at 16% progress of your online course and already feel that finally I am getting the concept and structure of the Vba. thnx for everyrhing.

@LeilaGharani

5 жыл бұрын

Thanks for the kind words. That's good progress on VBA! The beginning is the hardest part.

Best vid ever in this subject. I appreciate you for sharing this. Merci Leila :)

You are making VBA understandable even for me. That's some gift!

@LeilaGharani

5 жыл бұрын

I'm happy to hear that :)

Dear Leila.. the kind of knowledge and the skills you have to spread that knowledge is simply awesome.. thanks for all your knowledge sharing.. im a big fan of yours.. sincerely..

If i could like this twice I would. So brilliant and straightforward! Thank you!

@LeilaGharani

4 жыл бұрын

My pleasure. Thanks for the Like!

This was very helpfully in calculate my everyday Transactions Records working as wakala in Tz. So happy i found this.

thank you so much for taking part of your time to help other, may you find reward in this life and the next!!! you are brilliant

@LeilaGharani

4 жыл бұрын

You're very welcome. As long as it's helpful I am happy :)

Wow thank you, idk anything about VBA but I was able to follow along easily. You are amazing

Thanks so much for the easy-to-follow, professional video! Works like a dream on my Macbook. :)

Thank you Leila, That was amazing and easy to understand. Very helpful

Fabulous tutorial - Thank You. I'm not sure I totally understood the VBA (just bits of it), but I followed your instructions and my spreadsheet works perfectly. So chuffed.

@LeilaGharani

4 жыл бұрын

Great job!

Thank you, this is what i have been looking for a long time. It is really helpful. Big Thank

@LeilaGharani

5 жыл бұрын

You're very welcome. I'm glad the video is useful.

You are my Excel Guru...🙂 Thanks!

@vikascma

4 жыл бұрын

🙂🙂🙂

Flawless and thorough example of something that's been driving me nuts! Thank you so much!

@LeilaGharani

3 жыл бұрын

Glad it helped, John!

Wow....!! I have been using excel since 1997 but I wasn't aware of these fantastic function. You are just brilliant. I subscribe already.... I Love You...Mam. I am impressed so much. Many Many Thanks for sharing.......

@LeilaGharani

4 жыл бұрын

You're very welcome. Glad you found something new.

I have been using sum base on color for sometime but you have added something new. Thanks a million.

@LeilaGharani

5 жыл бұрын

You're very welcome Daniel.

Great video Leila !! Thanks for sharing !! Ctr+Shift+A is a very helpful shortcut do display the fuction arguments quickly.....

@LeilaGharani

5 жыл бұрын

You're very welcome Victor. Glad you like the video.

Thanks you so much. This is what i needed for a company project. Very clear and very useful! Considering following the VBA course now!

@LeilaGharani

4 жыл бұрын

Great to hear! I hope you'll like the course.

your way of explanation makes me to get in to excel and learn more and more. Last two years i have been continuously using various ideas from this site. Thanks a lot.

@LeilaGharani

5 жыл бұрын

You're most welcome. Thank you for your ongoing support.

Great value, finally I understand fantastic metod, I'm using Excel in spanish and it worked perfectly. Like for sure 👍🏼

This is extremely helpful! Thanks Leila!

Awesome video, competent and fast. Thx a lot!

As great as usual. Leila you are Queen of Excel. Thank you so much for this tutorial. Kind regards

@LeilaGharani

5 жыл бұрын

My pleasure. Glad you like the video.

This video is amazing! thank you so much!!! I needed this so much to make my budgets better :) thank you!!!!

I have checked some of your tutorials ...Amazing!!!

@LeilaGharani

5 жыл бұрын

I'm glad you like the tutorials.

Mam in every video you share miracle tricks, which not got on you tube. Love you mam...

@LeilaGharani

5 жыл бұрын

I'm happy to hear that the videos are useful.

Thanks once again Leila. May the good Lord richly bless

@LeilaGharani

5 жыл бұрын

You're very welcome Robert.

Thank you. This was amazingly useful. Simple tool to make and edit preliminary Gantt charts.

Hello Leila, I'm a new subscriber!! Thank you for the content you put out! You are super AWESOME!!!!

@LeilaGharani

5 жыл бұрын

Great to have you here José. I'm glad you like the content.

Thank you ,this is just what I was looking for .

super helpful this video. I had no idea how to create a custom function... also all these little details getting the active cell and a cell's colour. thanks muchly :)

Fantastic!! Thank you so much!

Thanks Leila, you really made it for my requirements. Thanks Again.

@LeilaGharani

5 жыл бұрын

I'm glad to hear that.

thanks again Leila for your best tutorials.

@LeilaGharani

5 жыл бұрын

You're very welcome.

Truly appreciate your work. Thank you very much

@LeilaGharani

5 жыл бұрын

You're very welcome. Glad you find the videos helpful.

Wow, looks great. That will be my next course after the I finish the excel course from yours.

@LeilaGharani

5 жыл бұрын

That's great Stephen. Looking forward to seeing you there.

I didn't even know this was possible despite using Excel for a long time. Many thanks. :)

@LeilaGharani

5 жыл бұрын

I'm glad you found something new.

it seems to be very useful even when dealing with a data matrix containing data where I want to show sum of values in different colored cells for each row... can't wait to check this out, have to clean my data first

Once again came with great work, u have made many of us rich & richer knowledge-wise. Just waiting for the next one very soon

@LeilaGharani

5 жыл бұрын

I'm happy the tutorial is helpful for you.

Thank you Leila. Excellent as allways.

@LeilaGharani

5 жыл бұрын

You're very welcome Enrique. Glad you like it.

Thank you Leila for letting us know about a new thing today.

@LeilaGharani

5 жыл бұрын

You're very welcome. Glad it is helpful.

You are an expert! 👍

Wow. This was amazing thanks!!!

This is a great video, amazing stuff. Thank you.

@LeilaGharani

5 жыл бұрын

You're very welcome. Glad you like the video.

I was struggling to do this very thing last week. Thank you.

@LeilaGharani

5 жыл бұрын

You're very welcome Michael. Glad I could help with that.

Excellent, Very useful. Thanks.

Thank for this Leila!

Thanks a lot Leila the video and trick was awesome you are a great teacher. Even though I am Lecturer myself I find your training and videos amazing. Thanks a lot.

@LeilaGharani

5 жыл бұрын

Thanks for the kind words. I'm glad you like the video.

Superb..!!! I feel Excel Team should bring this function permanently in workbook. Thanks for sharing solution..!!

@LeilaGharani

5 жыл бұрын

You're very welcome. Glad you like it.

Thanks for video!

An absolutely new aspect of Excel Never had an idea for any such possibility in Excel I am very much impressed Thank you

@LeilaGharani

5 жыл бұрын

You're very welcome. That's the beauty of Excel. A lot of possibilities.

@shabbirkanchwala-abwaab6263

5 жыл бұрын

@@@LeilaGharani How to know where to use Vlookup, Index/Match/Dget? Pls Help

@LeilaGharani

5 жыл бұрын

That's easy: always Index & Match :)

Thank you Leila, this is super cool, have a great day 🤗

@LeilaGharani

5 жыл бұрын

You're very welcome Katerina. Liebe Gruesse :)

Thanks very helpful video.

You truly are the excel goddess!!!

@LeilaGharani

5 жыл бұрын

😘

Hi Leila.. love that If Not Intersect() Is Nothing construct. Before understanding that concept, I used the overkill method of ActiveSheet.Calculate on the full Worksheet_SelectionChange event.. which made some of my workbooks very slow. Now, they are much speedier and more efficient. Thanks for the great videos, lessons and insights.. always something fun, new and interesting on your channel and web site. Thumbs up!!

@LeilaGharani

4 жыл бұрын

Thank you for the kind words and the thumbs up Wayne!

Very useful, thanks for sharing

One of the best tutor ever

@LeilaGharani

5 жыл бұрын

Aww, thank you!

Good Laxcering, Vary Usfoul., Thank you.

Thank you for this video. I been trying to find a way to do this for months. Well explain! Is there a anyway to add the hour to each cell?!

Huge thanks Leila. Your video tutorial is great and very informative and helpful. Thanks a lot.

@LeilaGharani

5 жыл бұрын

You're very welcome Amilcar. Glad you like the video.

@amilcarc.dasilva5665

5 жыл бұрын

@@LeilaGharani Yeah. You've done great work by sharing your expertise. Really appreciate. Keep it up.

Another great video tip. Thank you.

@LeilaGharani

5 жыл бұрын

You're very welcome Dennis. Glad you like the video.

This is fantastic. Thank you!

@LeilaGharani

4 жыл бұрын

Glad you liked it!

Thank you for your efforts it's the best and very helpfull lesson.

Excellent as always!

@LeilaGharani

5 жыл бұрын

Thank you. Glad you like it.

Very Interesting, although I never seemed to dive in VB. I started many times, every time I had a scenario, I always wondered how to do it with a formula. :) :)

Great tutorial. Thank you Leila. How should I save it, so the formula =SumColor is available on every excel file?

Thanks again for a great presentation as usual

@LeilaGharani

5 жыл бұрын

You're very welcome. Glad you like it Nissim.

Really helpful, Thanks

Great video!!

I love it great Tuto thanks a lot Leila

Superb! The Queen of excel really.

@LeilaGharani

5 жыл бұрын

I'm glad you like it :)

Hi Leila, Your tutorials are great . The script does not seem to work with conditional formatting colors. Do you have any idea how we can fixed that? If you can help us on this , you'll be a life saver. Thank you .

No one like you, you are great

@LeilaGharani

5 жыл бұрын

Thank you for the kind words!

Super erklärt! Vielen Dank!

nice work tnks!grt

Thank for your good videos!!!

@LeilaGharani

5 жыл бұрын

You're very welcome.

Thanks Leila, this was a helpful video

@LeilaGharani

5 жыл бұрын

You're welcome. I'm glad you like the video.

thanks very use full

Great stuff Leila 👏

@LeilaGharani

5 жыл бұрын

I'm glad you like it Heiko.

Thank you very much

simply love you

I have become a huge fan on how you help us and better ways to organise and visualise our data. Unfortunately while this is great when dealing with smaller ranges of data, excel 's performance is really letting me down when it comes down to dealing a large number of rows and references across multiple sheets. Any tip on how to boost the performance in corporate license environment would really help make the most out your tutorials! Great channel! Keep it up.

@LeilaGharani

5 жыл бұрын

You could check out this infographic: www.xelplus.com/speed-up-your-excel-files/

Thank you so much!!!!! 😭😭

Great presentation on a function I thought was not possible, but having trouble thinking where this would be useful.

@LeilaGharani

5 жыл бұрын

Maybe at some point it will come in handy. It's always good to know what is possible.

Hello Leila! am Rashid from Pakistan and these days i am practicing vba excel and i enrolled in your vba course on Udemy approx. one and half month ago

Hi Leila, I truly appreciate your work, I keep watching your videos as they are extremely informative and I keep learning new techniques in excel. I see this video has some VBA at a medium level. I wanted to learn VBA from a more beginner level and request you to advise me on where to start ..

@LeilaGharani

5 жыл бұрын

I have a VBA course that will take you from beginner to advanced. If you are interested you can check it out here: courses.xelplus.com/p/excel-vba-excel-macros

Thanks for formula and explain

@LeilaGharani

5 жыл бұрын

You're very welcome.

Thank you 😊

Thank you so much for such a great video as always. In the latest version of 365, this doesn't seem to refresh still. For anyone who wants to get around that, you can simply use the 'calculate now' button in the formulas tab. For further ease, record clicking that button as a macro and either create a button or associate a keybind.

@jclaudesanders

2 жыл бұрын

I was having this problem as well, and after an hour or so of research I found another workaround. If you add the line "Application.Volatile" (without quotations" to this Function it will force recalculate every time something in your worksheet changes.

@ivankaradzhov3610

Жыл бұрын

@@jclaudesanders Thanks!!!!!!!! ive been looking how to resolve this for over an hour until seeing your comment

Excellent again Leila

@LeilaGharani

5 жыл бұрын

Glad you like it.

Thanks Leila. Seems like I got to learn VBA for custom needs.

@LeilaGharani

5 жыл бұрын

It can really be helpful Peter.

@peternganga9371

5 жыл бұрын

@@LeilaGharani so I thought. Thank you as always. God grant you abundant energy to do the beautiful work you do here (online). I must say that I am your loyal student and has in return referred quite a number who feels the same. I have been a teacher and so can tell of a good one. You are one of the best. Thanks once again and God bless.

Leila thank you! Dream woman right there

@LeilaGharani

5 жыл бұрын

Glad you like it :)

Fantastic video: I think, assigning color to variable and than checking will have some overhead if multiple cells have this function. I would go with directly adding it under if condition because checking Boolean is faster than 2 step process of assigning than checking it. If cell.interior.color = matchColor.interior.color then.... will be faster. Thank you for your time Leila.

@LeilaGharani

5 жыл бұрын

Good idea. Thank you!

Thank you Leila. This was my first macro code as I had this use case. I understand the power of macros better now. I had one quick follow-up question on the ActiveSheet.Calculate. I was not able to copy and paste any cell within the range of columns I selected for the calculation to run. Is there a way to retain the copy-paste functionality within the selected range?

Thank you for the great tutorial! Is there a way to incorporate the sumproduct function? For example, I would like to sum all cells that have Canada on the row, 2020 on the column, sales on the column, and the cell is highlighted greed.

Very nice one deat! Beautiful!!! Small note: suppose the result cell has the same background as calculated cells, so then you can use: "If cell.Interior.Color = Activecell.Interior.Color"

Excellent

This was a great video, super helpful! One issue is that after I hit save, it no longer auto updates.

Very nice. We need VBA lessons.

@LeilaGharani

5 жыл бұрын

I'm glad to hear that.