Kirstin:
TO count how many cell have a certain colour you ned VBA. Chips have great
stuff on this at
http://www.cpearson.com/excel/colors.aspx
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only work
with
straight values in the cell?