Adding Cell Values Based on Color

[shanenavy26]

I have Column B Conditional Formatted based on Column A's data.

CATEGORY 1	100
CATEGORY 2	200
CATEGORY 1	150

<tbody>
</tbody>

CAT 1 TOTAL:

<tbody>
</tbody>

When I pick a category from a Drop List in A, I have B set to change to a certain color.

I know that you cannot add based on color when the cells are based on Conditional Formatting, so how can I make it work?

The condition I use for B is =$C2="Car"

 

[bugmonsta]

You can sum up column B based on the value of column A.
In the example below I am checking column A (A1 to A10) for the text CATEGORY 1, and if it finds it then to add up the value in column B

=SUMIF(A1:A10,"CATEGORY 1",B1:B10)