Excel 2003 :Summing specific cells of a particular color in a colu

[FLYNNE]

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

[Naveen]

"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

[Gord Dibben]

Visit Chip Pearson's site for working with colored cells.

http://www.cpearson.com/excel/colors.htm

See the SumByColor Function.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 05:12:01 -0700, FLYNNE <[email protected]>
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

Gord Dibben MS Excel MVP