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!
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
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
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.
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!
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!!
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?
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
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?
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?
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
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
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!
Most welcome
Thank you!!! This make it so easy! It was so confusing trying to do this by reading the instructions.
Amazing! All in 3 minutes! Thank you
Glad you enjoyed it!
Clear, easy-to-follow instructions; worked first time, thank you.
Thanks a lot David
Amazing! Yes, you totally deserve 2 thumbs up. Thank you for making this so easy and so helpful!
Glad you liked it!
Very helpful video, thank you very much
Most welcome
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!
Thanks a lot. Let me check
Did you ever get an answer to this? I am in the same place.
@@Freke17407 Not yet, hoping to hear still as this is such an awesome tool, but I can't use it with the rounding :)
@@Freke17407 In the code where it says "Dim cSum As Long" use "Dim cSum" instead
@@andrenamcphillips5746 In the code where it says "Dim cSum As Long" use "Dim cSum" instead
Good video, short, sweet and to the point.
Glad you liked it!
thank you very much for this, keep up the good work *heart*
Hi Thank you but the formula is showing an error, (saying: the formula contains unrecognized text). what to do now
Thank you for explaining in easiest way possible.🤟
Thank you....... You have solved my problem, God bless you.......
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.
X E lent work buddy
Thanks a lot
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
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
Did you figure this out? im having the same problem
I had the same issue. Did you figure out the remedy?
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
I had the same issue, thanks for solving it@@enginarmagancelik9260
@@enginarmagancelik9260 glad that I've seen this comment. Thank you! and also thank you dptutorials
very helpful, but if you add a color then you need to refresh the formula,
but its a helpful code
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.
same question.. @dptutorials
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
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!
This is so motivating my friend. Thanks a lot for this wonderful feedback.
question is.. can I use this to my mobile excel 😭
Amazing formula and its more helpful... thank you so much for this video...
Excellent
Thank you! Cheers!
great sir
Thanks a lot.
Really work thish trick😘😘😘
Enjoy
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!!
Same here
save as " Macro Enabled Workbook"
When chaning the color or using Undo, the formula doesn't work. Is there a soluton for this?
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?
thank you for sharing, but when I calculate the data with decimal numbers, the result will automatically round down. how to handle that issue
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
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
Yes it will
@@dptutorials No. It WILL NOT!
save as " Macro Enabled Workbook"
thanks a lot.
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?
Me too
Is there a way to use this code and not lose autosave functionality?
Very nice Mr. It works well I tried thank you.
But it doesn't calculate decimal digits
Thank you! Cheers!
@ihsanullah Stanakzai, In the code where it says "Dim cSum As Long" use "Dim cSum" instead
THANKU GET RESULT................
İt is working
goood
Welcome
Sir,Can I get Code?
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?
Most welcome, please subscribe for more videos.
Good, but it doesn't work for decimal numbers. Could you please make another video with decimal numbers. Thank you in advance
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
Hi the VBA code disappears after saving. Please help
Bro it was applicable when I insert your code. After all, the code has been deleted automatically. What can I do
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
Needs VBA code to refresh formula if fill in (cell color) is changed.
CAN WE USE SUMIF FUNCTION WITH THIS CODE
Hi, it says Invalid Outside Procedure. What should I do to correct? Thank you
Please share the excel and find out the mistake. Write me at info@dptutorials.com
Im getting value error for a column i did with this code. Pls help
thanks a lot
Most welcome
But it displays an error value when the sum is larger than 2 billion. Please help to resolve this issue.
although if you change the colour of the cell the sum does not update
how do I sum base one another cell color
Doesn't work if color uses conditional formatting?
Hi where is the code.. cant see anywhere . Can u help please
HOW CANE I APPLY THIS CODE FOR COUNTA FUNCTION ........I TRYED REPLACE BY SUM TO COUNTA...... BUT THIS IS NOT WORKING
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
save as " Macro Enabled Workbook"
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
Please mail me the excel sheet at dptutorials15@gmail.com
Working for only 1 color for another colour it's same.
I try but it’s rounding the number
Am getting the error type not defined
Where is the VBA code?
I am getting error, #NAME? can anyone please help me?
Hi,
THE COUNT NOT ACCURATE !. THE 0.99 NOT ADD IT OR AROUNDED !. SO SOMETHING MISSING IN THE FORMULA !
I’m only getting 0 despite using matching color.
NOT WORKING
Error
Not workin
nor working matee !!!!!!!
Not working