View Single Post
  #1   Report Post  
Quilp Quilp is offline
Junior Member
 
Posts: 27
Default 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?