SUM BASED ON CELL COLOR

[neeraj2050]

Greetings!!
I have an excel file, into which few are color cells and rest are non color cells. And this data will get updated. All I want is to sum the color cell data and non color cell data separately.
I shall appreciate non vba solution.
Regards
Neeraj Kumar Agarwal

 

[bobhc]

There is no formula/function to do as you need you will need a UDF in VBA.

https://www.google.co.uk/search?q=f...&ved=0ahUKEwjX_LfB-6vMAhVHXhoKHdFwB8EQBQgaKAA


.

 

[Chihiro]

If VBA can't be used for one reason or another. You can use helper column (or table) to index color.

See attached.

 

[neeraj2050]

Sir,

I do appreciate your idea. But my data keeps changing and it is vast. So this idea might not work here.

Regards
Neeraj Kumar Agarwal

 

[Chihiro]

There must be some condition/logic used to assign colour(s) to your cells right?

Use that same logic to assign text to a adjacent cell or in another table. Just add line as you add line to your data.

Other than that, as bobhc stated, you'd need VBA.

 

[neeraj2050]

Appreciate your help. Thanks a lot!!