Count By Color

[beb1227]

I would like to know if it is possible to count by Color...I have seen several posts that this can be done.



I would like to have this done within a given date range....

Here is the basic formula I am using....to get the total count within my defined date range.

=SUMPRODUCT(($D$8:$D$999>=$F$2)*($D$8:$D$999<=$F$3 ))

Any help on this is greatly appreciated

[Colin Legg]

What is the underlying logic that determines if a cell is coloured in a particular way?

It is better to use this underlying logic to do the conditional count rather than the cell colour itself.

[beb1227]

this is a minor piece of what i am looking to build....

but the color is used when a certain person does something....each memeber of the team has a color.

so say step one is process a request.....I would want it to look down the column for Process request, in the given date range....and tell me how many times it sees the color yellow, Gray, Blue....etc

granted the sheet that I would do this....each color would have its own cell...so a tolal for yellow
a total for blue
a total for gray.

[Colin Legg]

Hi,

I'll explain the problem(s) with counting by colours.

Excel 2007 does not have a built-in worksheet function which can count by colour. This means that you would have to write a custom VBA function (this is called a "UDF") to do it. Even then, the UDF wouldn't automatically recalculate when the colour of a cell changes because changing the colour of a cell doesn't trigger a calculation event. This solution isn't very good.

If the colour of the cell is determined by the name of a person then you should aim to count by name rather than by colour. You can do this using COUNTIF() or you could even use a pivot table.

[beb1227]

yeah, that is kinda what I have thought when reading how to do this...if doing it at all.

this is a minor piece of the table I am trying to set up....but would have been cool if it could be done easily.

at this point the names are not put in though.....seeing as the log is already way to large as it is.

thanks for the help on this issue.