How To Sum Cells based on Background Color in Excel || Excel Tips

[@DanaDana-qc8gi]

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.

[@jpr1111]

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

[@stephaniemoorewhite5616]

Amazing! Yes, you totally deserve 2 thumbs up. Thank you for making this so easy and so helpful!

[@dptutorials]

Glad you liked it!

[@ashutoshbhosale7472]

Thank you for explaining in easiest way possible.🤟

[@davidclark5291]

Clear, easy-to-follow instructions; worked first time, thank you.

[@dptutorials]

Thanks a lot David

[@stephaniemoorewhite1457]

Amazing! All in 3 minutes! Thank you

[@dptutorials]

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-1]

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

[@riohandoko6829]

thank you for sharing, but when I calculate the data with decimal numbers, the result will automatically round down. how to handle that issue

[@carinacabral2846]

Good video, short, sweet and to the point.

[@dptutorials]

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?

[@minakhaliloo]

Me too

[@piyushprajapat7310]

Really work thish trick😘😘😘

[@dptutorials]

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

[@abdulahadsamadi9457]

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

[@nancyw6348]

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!

[@dptutorials]

This is so motivating my friend. Thanks a lot for this wonderful feedback.

[@nadiahhalim5856]

question is.. can I use this to my mobile excel 😭

[@andrenamcphillips5746]

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!

[@dptutorials]

Thanks a lot. Let me check

[@Freke17407]

Did you ever get an answer to this? I am in the same place.

[@andrenamcphillips5746]

@@Freke17407 Not yet, hoping to hear still as this is such an awesome tool, but I can't use it with the rounding :)

[@LascellesClarke]

@@Freke17407 In the code where it says "Dim cSum As Long" use "Dim cSum" instead

[@LascellesClarke]

@@andrenamcphillips5746 In the code where it says "Dim cSum As Long" use "Dim cSum" instead

[@Ali-kd8ec]

İt is working

[@aljondelaluz243]

very helpful, but if you add a color then you need to refresh the formula, but its a helpful code

[@kiritoken8015]

thank you very much for this, keep up the good work *heart*

[@christophermartinez506]

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?

[@shiyamsathiyajith2325]

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.

[@hasmukhshah7090]

Excellent

[@dptutorials]

Thank you! Cheers!

[@workkea1757]

Good, but it doesn't work for decimal numbers. Could you please make another video with decimal numbers. Thank you in advance

[@riohandoko6829]

In the code where it says "Dim cSum As Long" use "Dim cSum" instead

[@dsbohra]

X E lent work buddy

[@dptutorials]

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

[@roblee5016]

I had the same issue, thanks for solving it@@enginarmagancelik9260

[@injeff]

@@enginarmagancelik9260 glad that I've seen this comment. Thank you! and also thank you dptutorials

[@8prabha]

I am getting error, #NAME? can anyone please help me?

[@user-nf3ve9ih7b]

thanks a lot.

[@user-gj9jw6pi4j]

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"

[@JosephBut]

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.

[@riohandoko6829]

same question.. @dptutorials

[@riohandoko6829]

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

[@securesquare]

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!!

[@srirajjayaprakash3852]

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 [e-mail]

[@jetsetter8]

although if you change the colour of the cell the sum does not update

[@tippu74]

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?

[@ihsanullahstanakzai6049]

Very nice Mr. It works well I tried thank you. But it doesn't calculate decimal digits

[@dptutorials]

Thank you! Cheers!

[@LascellesClarke]

@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-td4df]

Amazing formula and its more helpful... thank you so much for this video...

[@tomipedelaborde]

thanks a lot

[@dptutorials]

Most welcome

[@obykanoby]

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?

[@dptutorials]

Most welcome, please subscribe for more videos.

[@rayvanrensburg93]

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

[@dptutorials]

Please mail me the excel sheet at [e-mail]

[@Abendingtimespace]

I try but it’s rounding the number

[@sam6524]

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

[@dptutorials]

Yes it will

[@LascellesClarke]

@@dptutorials No. It WILL NOT!

[@enginarmagancelik9260]

save as " Macro Enabled Workbook"

[@shanoobolavanna]

CAN WE USE SUMIF FUNCTION WITH THIS CODE

[@sindujapolana4254]

Am getting the error type not defined

[@mdalaminahamedrahit550]

how do I sum base one another cell color

[@amrahmed3348]

goood

[@dptutorials]

Welcome

[@htetshine7215]

Sir,Can I get Code?

[@vaibhavmbpatil875]

NOT WORKING

[@yasserdusuki8374]

Where is the VBA code?

[@atlasprime6193]

I’m only getting 0 despite using matching color.

[@karimullahkhanMMM]

Not workin

[@nurulathiqah3298]

Error

[@florinparaschiv9006]

nor working matee !!!!!!!

[@armancochangco8208]

Not working