Adding By Color

  • Thread starter Thread starter GR
  • Start date Start date
G

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
 
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 yo
can't fathom it out, I have a free add in available that has somethin
similar as a function. If you would like this please send an e-mail t
(e-mail address removed).

HTH

Dominic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error with countif formula on when adding linked spreadsheets 0
Offset, sum down to the first blank row 6
Add values based on text color with the criteria of a date 7
Using count function for multiple columns 1
How to extract separated text by many commas in Excel? 0
Text Colour 5
Formula for success... corny I know 4
Conditional Format 2007 1

Back
Top