Sum Cells Based on Their Color in Excel (Formula & VBA) скачать в хорошем качестве

Sum Cells Based on Their Color in Excel (Formula & VBA)

In this video, I will show you three different methods to add cells based on color. 00:00 Intro 00:25 SUM by Color Using SUBTOTAL Function 02:05 SUM by Color Using VBA Function 08:27 SUM by Color Using Get.CELL + Named Range Trick If you're looking for an easy one-time method, use the first SUBTOTAL method. If you need to do this quite often and are comfortable with VBA, you can create your own custom function that will give you the sum of cells based on the color in it. And if you don't prefer VBA, then you can use the third method which uses an old GET.CELL formula trick. It's not the best way to do this, but it gets the work done. ---------------- 'Code created by Sumit Bansal from https://trumpexcel.com/ 'This VBA code created a function that can be used to sum cells based on color Function SumByColor(SumRange As Range, SumColor As Range) Dim SumColorValue As Integer Dim TotalSum As Long Dim rcell As Range SumColorValue = SumColor.Interior.ColorIndex Set rCell = SumRange For Each rCell In SumRange If rCell.Interior.ColorIndex = SumColorValue Then TotalSum = TotalSum + rCell.Value End If Next rCell SumByColor = TotalSum End Function ---------------- ✅ Download File: https://swiy.io/sumbycolor ✅ Personal Macro Workbook Video:    • Personal Macro Workbook - Reuse Macros in ...   ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c... ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... #Excel #ExcelTips #ExcelTutorial