• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum Based on Adjacent Colour Cell

Dear Excel Gurus

Please find attached Excel Sample File.

I want the SUM based on its Adjacent Cell Colour.

Thanx & Regards!

Suhas
 

Attachments

  • Sum-Based-On-Colour.xlsm
    9.8 KB · Views: 5
SUHAS KARHADKAR
Would You reread Forum Rules:
There is a line as below:
  • Please post, new posts in the correct forums, not as Emails/Messages to people
You've posted Your thread to VBA Macros ... then You have had a clear idea to get VBA Macros -solution --- then I won't even think to offer any formulas.

What would mean You term
simple?
Normally, it would mean double work!

My previous solution works with Your newer file as well - but the results comes as it You can see from this file - click three times.

Your sample colors ... could figure as those colors ... but to compare color to color would work.
If You have more than 600 rows ... then why You give six rows as a sample?
... and this works even if there would be less than 600 rows.
 

Attachments

  • Sum-Based-On-Colour 06122020.xlsb
    15.5 KB · Views: 9
SUHAS KARHADKAR
Would You reread Forum Rules:
There is a line as below:
  • Please post, new posts in the correct forums, not as Emails/Messages to people
You've posted Your thread to VBA Macros ... then You have had a clear idea to get VBA Macros -solution --- then I won't even think to offer any formulas.

What would mean You term
simple?
Normally, it would mean double work!

My previous solution works with Your newer file as well - but the results comes as it You can see from this file - click three times.

Your sample colors ... could figure as those colors ... but to compare color to color would work.
If You have more than 600 rows ... then why You give six rows as a sample?
... and this works even if there would be less than 600 rows.


Dear vletm Sir,

Apologize for inconvience.
Got the Solution.

Thanx & Regards!

Suhas
 
Back
Top