Thread: Adding By Color
View Single Post
  #3   Report Post  
GR
 
Posts: n/a
Default

Thank you very much!
GR


"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
Take a look at
http://www.cpearson.com/excel/colors.htm

"GR" wrote in message
...
I have a row of numbers, some black and some blue. Is it possible to set
up a formula to look at the entire row and (i) return the sum of only the
black numbers and (ii) update the sum each time I change the color of a
number from blue to black? If so, I would appreciate guidance!
Thank you,
GR