Hi,

Am Mon, 15 Dec 2014 19:25:51 +0000 schrieb Quilp:

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?

you could use Filter by color = No fill and then
=Subtotal(9,A1:A20)
Modify range to suit.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional