View Single Post
  #2   Report Post  
Old July 1st 08, 01:17 PM posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default Summing Cells by Color


What causes the cells to be Red?
Is it formatting where negative numbers are Red?
If so, then
If they are Red because of Conditional Formatting, then let us know the
formula you are using for the condition.
Roger Govier

"Dtemp" wrote in message
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.