Sum Up Highlighted Only Rows

[Beckerboards]

My boss asked me to look into this ... so no pressure or anything ...

I need to be able to sort cells based on color conditions.

Example to explain my needs:
column1 [fruit]----------column2 [#]
---------------------------------------------------------
Apple ----------------------2 (Highlighted Red Cell)
Grape ----------------------2 (Highlighted Purple Cell)
Apple ----------------------1 (Highlighted Red Cell)

Lets say that I need to sum up the amount of Apples (in column2).
Since this sheet is continuously being added to, it would be nice to be able to sum up the highlighted rows. How do I do this?

I hope this makes sense ... Thanks.

[JBeaucaire]

Doing math by color coding is a horrible technique. Math is hard enough to do on numbers and text comparisons, throwing colors into it is unwise and unnecessary.

What is turning those cells red/purple? Conditional Formatting? (I hope!) ...or are you manually doing it? Anything CF is doing can be turned into a normal cell formula and used to enter numeric values instead of actual colors. Heck, even the WORD "red" or "Purple" is easier to do math on than the actual color.


TIP:
Whatever methodology/mentality that is being used to color a cell can be used IN a cell to enter an index # instead. Red...1 Purple...2 Blue...3

With numbers in a column, doing math with SUMIF() is easy.

[Beckerboards]

This was my first reaction as well ...
I am using CF to originally highlight the cells.
I am thinking I can associate a number value with the cell color based on conditioning and hide that row.

Problem solved. Thanks for helping me out!

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]