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

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