Adding by font colour in Excel
 

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

Adding by font colour in Excel
 

Have a look he-

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

Mike

"Zakynthos" wrote:

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

Adding by font colour in Excel
 

Mike,

Many thanks

Tony

"Mike H" wrote:

Have a look he-

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

Mike

"Zakynthos" wrote:

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