ExcelBanter - Can I total only numbers with a specific font color?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I total only numbers with a specific font color? (https://www.excelbanter.com/excel-discussion-misc-queries/61147-can-i-total-only-numbers-specific-font-color.html)

BLillie11

Can I total only numbers with a specific font color?

I have a column of numbers with different color fonts. Is there a way to
create a formula to total only those numbers with a specific font color? For
example, only the cells whose font has been formatted red?

JE McGimpsey

Can I total only numbers with a specific font color?

See

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

In article ,
BLillie11 wrote:

I have a column of numbers with different color fonts. Is there a way to
create a formula to total only those numbers with a specific font color? For
example, only the cells whose font has been formatted red?

All times are GMT +1. The time now is 07:57 PM.