sum up a column ignoring values coloured red
I have a column of monetary values for which I need to find the sum total but excluding the rows where the value is coloured red. If this is not possible, can I enter the values, that I wish to ignore, in some other way e.g bold, italic etc?
|