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 |
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 . HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=376911 |
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 |
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 |
All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com