Adding by font colour in Excel

[Zakynthos]

I have a spreadsheet with values formatted in one column in red and some in
black.

What function or formula can I use to count only the numbers in red?

many thanks

 

[Mike H]

Have a look here:-

http://www.xldynamic.com/source/xld.ColourCounter.html#summing

Mike

 

[Zakynthos]

Mike,

Many thanks

Tony

Have a look here:-

http://www.xldynamic.com/source/xld.ColourCounter.html#summing

Mike