How do I sum up values only in cells that are color filled?

Each cell that filled with "red" represents player A, "blue" player B, etc.
In each cell is also a score (some value). I want to total the scores for
player A (the values in all the red cells) and player B (the values in all
the "blue" cells), etc.

Hi

check out Chip Pearson's notes on this at
http://www.cpearson.com/excel/colors.htm

Cheers
JulieD

"TryingExcel" <[email protected]> wrote in message
news:[email protected]...
> Each cell that filled with "red" represents player A, "blue" player B,
> etc.
> In each cell is also a score (some value). I want to total the scores for
> player A (the values in all the red cells) and player B (the values in all
> the "blue" cells), etc.

There is a solution at
http://www.xldynamic.com/source/xld.ColourCounter.html, but note 2 things

Firstly, if there is a worksheet change that triggers a recalculation, the
colour count does not update. Secondly, if you change a colour of one of the
cells, the count does not update, as a colour change does not trigger a
recalculation.

The former can be changed by adding 'Application Volatile' to the code. The
second is trickier, so I tend to use a button to set a cell's colour, and
have that button code force a recalculation.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TryingExcel" <[email protected]> wrote in message
news:[email protected]...
> Each cell that filled with "red" represents player A, "blue" player B,
etc.
> In each cell is also a score (some value). I want to total the scores for
> player A (the values in all the red cells) and player B (the values in all
> the "blue" cells), etc.

On Wed, 5 Jan 2005 23:11:01 -0800, "TryingExcel"
<[email protected]> wrote:

>Each cell that filled with "red" represents player A, "blue" player B, etc.
>In each cell is also a score (some value). I want to total the scores for
>player A (the values in all the red cells) and player B (the values in all
>the "blue" cells), etc.

How does the cell get filled with a color?

If the color is there because of conditional formatting, then you will need to
use the same formula in your SUM(scores) formula.

Something like =SUMPRODUCT((Player="A")*Scores)


--ron