Sum based on cells of specific color only

[anuradhagrewal]

Hi
I need your help in calculating the total sums of all the cells with yellow color.
As per the example mentioned below are two columns mainly Name(C) and sales for the month (D)
Now as you can see there are certain cells in the Name column (C) like C4,C7,C13 and so on which turn yellow.
I need the to display in cell D2 a sum total of sales value for all the individuals whose cell is highlighted in yellow.
Like the value of say James is 9449 ,Michael is 14037 ... and so on the SUM of the total sales of these yellow(any color in the future) highlighted cells.

Please help

Regards

Anu

 

[arthurbr]

And how were these cells colored? Conditional formatting? Manually?

 

[anuradhagrewal]

And how were these cells colored? Conditional formatting? Manually?

Hi there
The color is based on conditional formatting and hence the selected names to change.

In addition it is not possible to filter by color as the total comes of all cells.

Plz suggest

Any

 

[etaf]

The color is based on conditional formatting and hence the selected names to change.

whats the rule used for the conditional formatting , as that can be used to also use as a SUMIF() SUMIFS() potentially

 

[decent_boy]

Please check below link if this helps you
Check here GET.CELL

How to Sum by Color in Excel (Formula & VBA) - Trump Excel

Excel has some really amazing functions, but it doesn't have a function that can sum cell values based on the cell color.

trumpexcel.com

 

[Fluff]

@decent_boy Get.Cell does not recognise conditional formatting.