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.

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.