"SumIf" will not serve the purpose.

Try using conditional Formating & SumIf together.

Use same condition in Conditional Formating & SumIf




"FLYNNE" wrote:

I have an excel worksheet in which a column contains some cells in which the
monetary values are coloured blue.

Is there some function I could use to sum only these coloured values ?

I have been told to use the SUMIF function , but I am unsure how to use it
with respect to coloured fonts.

Suggestions most welcome.

Regards

--
FLYNNE