Out of sight (to the right) or hidden. Using the same criteria (IF-function) as you used to make it red, make it 0 (if not red) or just plain positive (if red). Use SUM-function to total the values so derived.
Hope this helps.
I am using Office 2003. I have a column of numbers F4:F29. I have used conditional formatting to turn the font of the dollar amount red if certain criteria are met (I had used Vlookup to get the dollar amont in the the cells F4:F29). I want to add the "red" dollar amounts together with another number from cell C3- and place that in cell K4. Is this possible?