Adding By Color

[GR]

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

[dominicb]

Good evening GR

Chip Pearson discusses this very subject on his website:

http://www.cpearson.com/excel/colors.htm

It's not that difficult a thing to do and it's well documented. If you can't fathom it out, I have a free add in available that has something similar as a function. If you would like this please send an e-mail to [email protected].

HTH

DominicB

[N Harkawat]

Take a look at
http://www.cpearson.com/excel/colors.htm

"GR" <[email protected]> wrote in message
news:[email protected]...
>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
>

[GR]

Thank you very much!
GR


"N Harkawat" <nharkawat@hotmail_dot_com> wrote in message
news:[email protected]...
> Take a look at
> http://www.cpearson.com/excel/colors.htm
>
> "GR" <[email protected]> wrote in message
> news:[email protected]...
>>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
>>
>
>