Required - Excel Formula to do a summation based on a unique color.

[James Perry]

Cells c6:c50 contain some numeric values.
I select c6, c7, c15, c33, c35, c39 and fill-color these cells with the color yellow.
In cell C51 i want a summation of only the cell values that have the color yellow.
What Excel formula can do the needful.
Thank you.

 

[Somendra Misra]

Hi James,

See the file. Go through Name manager for named formula to return cell colour.

Regards,

 

[James Perry]

Thanks, Somendra. That was quick. I'm trying it out.
Thanks again.