Wow! I used the code and it works like magic. Unlike other video, I don't need to type in the code, just copy and paste. Thank you!
@dptutorials Жыл бұрын
Most welcome
@Sheriff_Bruce_LeeАй бұрын
Thank you! This saved me a LOT of work. I'm telling my wife we're gonna be having another kid just so I can name them after you.
@jpr11113 ай бұрын
Thank you....... You have solved my problem, God bless you.......
@ammarrafi1402 Жыл бұрын
Hi Thank you but the formula is showing an error, (saying: the formula contains unrecognized text). what to do now
@stephaniemoorewhite56162 жыл бұрын
Amazing! Yes, you totally deserve 2 thumbs up. Thank you for making this so easy and so helpful!
@dptutorials2 жыл бұрын
Glad you liked it!
@ashutoshbhosale74724 ай бұрын
Thank you for explaining in easiest way possible.🤟
@davidclark5291 Жыл бұрын
Clear, easy-to-follow instructions; worked first time, thank you.
@dptutorials Жыл бұрын
Thanks a lot David
@stephaniemoorewhite14572 жыл бұрын
Amazing! All in 3 minutes! Thank you
@dptutorials2 жыл бұрын
Glad you enjoyed it!
@nimeshaherath2189Ай бұрын
But it displays an error value when the sum is larger than 2 billion. Please help to resolve this issue.
@ScissorsPaperMusic Жыл бұрын
What I figured out is, if you have a color asigned to a value (a price for example) and you change the background color, the summ doesnt get automatically updated. You have to change a single value in the column to have it updated. Same for if you assign a color AFTER entering a price into it. Any fix for this by any chance guys?
@VilasPande-ElectricalPannelC-12 ай бұрын
Dear sir, Thanks for guiding me to resolve such a problem. Though I'm a beginner in VBA programming. Pl. guide to add two decimals in result. For example, the Sum result should show 212.29 but it shows 212. Thank you once again
@riohandoko68292 ай бұрын
thank you for sharing, but when I calculate the data with decimal numbers, the result will automatically round down. how to handle that issue
@carinacabral28463 жыл бұрын
Good video, short, sweet and to the point.
@dptutorials3 жыл бұрын
Glad you liked it!
@avagara973 Жыл бұрын
How can I save the code because when I close the app and comeback to work on it, this code vanished, I most to right it again!! do you have the way to fix this problem?
@minakhaliloo11 ай бұрын
Me too
@piyushprajapat73102 жыл бұрын
Really work thish trick😘😘😘
@dptutorials2 жыл бұрын
Enjoy
@drielymatias7598 Жыл бұрын
Very helpful video, thank you very much
@dptutorials Жыл бұрын
Most welcome
@toshiyo822 Жыл бұрын
Hi the VBA code disappears after saving. Please help
@pandharinathjoshi6565 Жыл бұрын
Hi sir, I am doing Conditional format, that colour not working sir, pls advice sir its shows 0 sir....Its not working Condition Format sir
@abdulahadsamadi94573 ай бұрын
Thank you, it should be applied to each Excel sheet to sum the color, and it doesn't work in general. waiting for your feedback
@nancyw63482 жыл бұрын
I wish I could give you two thumbs up my friend. This video was straight forward and simple to follow. Thank you for sharing this awesome way to sum cell values based on cell color in Excel!
@dptutorials2 жыл бұрын
This is so motivating my friend. Thanks a lot for this wonderful feedback.
@nadiahhalim5856 Жыл бұрын
question is.. can I use this to my mobile excel 😭
@andrenamcphillips57462 жыл бұрын
Hi, thank you for this tutorial! This has been awesome. I wondered if you might be able to help - I have used your coding the the final result is rounding the sum to .00 rather than just showing what's been added up (eg the total sum = $239.23, but the cell is displaying $240). How do I fix this to remove the rounding? I am using these summed up numbers to on-charge other clients so can't lose what happens after the decimal points :) Thanks in advance!
@dptutorials2 жыл бұрын
Thanks a lot. Let me check
@Freke174072 жыл бұрын
Did you ever get an answer to this? I am in the same place.
@andrenamcphillips57462 жыл бұрын
@@Freke17407 Not yet, hoping to hear still as this is such an awesome tool, but I can't use it with the rounding :)
@LascellesClarke2 жыл бұрын
@@Freke17407 In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@LascellesClarke2 жыл бұрын
@@andrenamcphillips5746 In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@Ali-kd8ec Жыл бұрын
İt is working
@aljondelaluz2434 ай бұрын
very helpful, but if you add a color then you need to refresh the formula, but its a helpful code
@kiritoken80157 ай бұрын
thank you very much for this, keep up the good work *heart*
@christophermartinez5064 ай бұрын
Is there a way to use this code and not lose autosave functionality?
@nielswillemsen7415 Жыл бұрын
When chaning the color or using Undo, the formula doesn't work. Is there a soluton for this?
@shiyamsathiyajith232510 ай бұрын
Im getting value error for a column i did with this code. Pls help
@libincherian1846 Жыл бұрын
Bro it was applicable when I insert your code. After all, the code has been deleted automatically. What can I do
@pandharinathjoshi6565 Жыл бұрын
great sir
@dptutorials Жыл бұрын
Thanks a lot.
@hasmukhshah709011 ай бұрын
Excellent
@dptutorials11 ай бұрын
Thank you! Cheers!
@workkea17575 ай бұрын
Good, but it doesn't work for decimal numbers. Could you please make another video with decimal numbers. Thank you in advance
@riohandoko68292 ай бұрын
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@dsbohra11 ай бұрын
X E lent work buddy
@dptutorials11 ай бұрын
Thanks a lot
@liam8515 Жыл бұрын
Hi, very helpful video. I am working with decimal points but the formula is rounding these up when summing. Is there an alternative to “integer” we can use in the code to get exact result instead of rounding up? Thanks
@ArielleThalia Жыл бұрын
Did you figure this out? im having the same problem
@TheBestPersonYouKnow Жыл бұрын
I had the same issue. Did you figure out the remedy?
@enginarmagancelik9260 Жыл бұрын
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@roblee50169 ай бұрын
I had the same issue, thanks for solving it@@enginarmagancelik9260
@injeff7 ай бұрын
@@enginarmagancelik9260 glad that I've seen this comment. Thank you! and also thank you dptutorials
@8prabha3 ай бұрын
I am getting error, #NAME? can anyone please help me?
@user-nf3ve9ih7b6 ай бұрын
thanks a lot.
@user-gj9jw6pi4j10 ай бұрын
THANKU GET RESULT................
@narse_2166 Жыл бұрын
I have a problem with the save.... when i close the excel and open it again, it's not saved the code... why? i follow the all of the steps 1 by 1.... what is wrong? office 19
@enginarmagancelik9260 Жыл бұрын
save as " Macro Enabled Workbook"
@JosephBut3 ай бұрын
Thank you for the formula, I can use the SumByColor to do my report. However, I am not able to get the figures after the decimal point, can you help to re-write the formula including figures after the decimal point? Thank you.
@riohandoko68292 ай бұрын
same question.. @dptutorials
@riohandoko68292 ай бұрын
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@dutarnab Жыл бұрын
Hi where is the code.. cant see anywhere . Can u help please
@securesquare2 жыл бұрын
How do we count cells by sumcolour for conditionally formatted color, I have two colors in a column which obtained by conditional formatting (formula based), but when i applied sumcolour it considering both colors same, Any Idea or advice please!!
@srirajjayaprakash38522 жыл бұрын
Same here
@enginarmagancelik9260 Жыл бұрын
save as " Macro Enabled Workbook"
@ishelou Жыл бұрын
Hi, THE COUNT NOT ACCURATE !. THE 0.99 NOT ADD IT OR AROUNDED !. SO SOMETHING MISSING IN THE FORMULA !
@ZayamGaming Жыл бұрын
Hi, it says Invalid Outside Procedure. What should I do to correct? Thank you
@dptutorials Жыл бұрын
Please share the excel and find out the mistake. Write me at info@dptutorials.com
@jetsetter8 Жыл бұрын
although if you change the colour of the cell the sum does not update
@tippu742 жыл бұрын
HOW CANE I APPLY THIS CODE FOR COUNTA FUNCTION ........I TRYED REPLACE BY SUM TO COUNTA...... BUT THIS IS NOT WORKING
@nyongcahngapak Жыл бұрын
Doesn't work if color uses conditional formatting?
@ihsanullahstanakzai60493 жыл бұрын
Very nice Mr. It works well I tried thank you. But it doesn't calculate decimal digits
@dptutorials3 жыл бұрын
Thank you! Cheers!
@LascellesClarke2 жыл бұрын
@ihsanullah Stanakzai, In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@Reenaa_0814 Жыл бұрын
Working for only 1 color for another colour it's same.
@RajeshKumar-td4df9 ай бұрын
Amazing formula and its more helpful... thank you so much for this video...
@tomipedelaborde2 жыл бұрын
thanks a lot
@dptutorials2 жыл бұрын
Most welcome
@obykanoby2 жыл бұрын
Thank you for the video, however after having completed all the steps, when i type the formula in the end and press enter, intead of the sum of the numbers inside the coloured cell, it types 0). What am i doing wrong?
@dptutorials2 жыл бұрын
Most welcome, please subscribe for more videos.
@rayvanrensburg933 жыл бұрын
Hi, Hope you are well, everyone show how to sum cells based on background color, but cant seem to find a way to have a cell that counts the whole row based on the amount of a certain color in that row (No values in the color cells). for instance if there is 31 days with a row of cells under each day with different colors, where 7 days is one color 5 days is another color and 9 other days is another color. to calculate each color automatically and give me the result in my allocated cells of how many of those colors appeared in that row? hope you understand my question
@dptutorials3 жыл бұрын
Please mail me the excel sheet at dptutorials15@gmail.com
@Abendingtimespace5 ай бұрын
I try but it’s rounding the number
@sam65243 жыл бұрын
Just I saw three videos every body explained well. But where you are saving VBA code files and will it work for other sheets same time or need to create new. Please if you can advise. Thanks