Sheet formula to sum by font colour

[stuartgb100]

In a numerically formatted column I have numbers in both red and black fonts. How can I sum the column excluding the red values please ? Separately, how can I just sum the red values ? Thanks.

 

[Joe4]

It makes a difference how the fonts are colored.

If they are colored by Conditional Formatting, you can usually use the same coniditions that you used for Conditional Formatting in a SUMIF, SUMIFS, or SUMPRODUCT formula to get your sum.

If the fonts are colored manually, then you will require VBA, as Excel formulas only work off of values, not formats.
See here for how to do that: How to count or sum cells based on the font colors in Excel?

 

[stuartgb100]

It makes a difference how the fonts are colored.

If they are colored by Conditional Formatting, you can usually use the same coniditions that you used for Conditional Formatting in a SUMIF, SUMIFS, or SUMPRODUCT formula to get your sum.

If the fonts are colored manually, then you will require VBA, as Excel formulas only work off of values, not formats.
See here for how to do that: How to count or sum cells based on the font colors in Excel?

Great, many thanks. It'll be VBA for me then.

 

[Joe4]

You are welcome.