How to add numbers in a column dependant on their colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with numbers in 2 different colours in each column. Is
there a formula I can use to total only numbers in one colour?
 
it depends on how thee colors are applied.
If the colors are from conditional or custom formating. the same criteria
for the formating can be used in a sumproduct() or similar formula.
If the colors were changed by hand, a macro will be needed.
something like the one in
http://www.cpearson.com/excel/colors.htm
 
Back
Top