Counting all cells with red font in Excel
 

I want to COUNT (not sum) all the cells in a column that are formatted in RED.

What function/formula can I use for this?

Counting all cells with red font in Excel
 

Counting or summing, have a look he-

http://www.xldynamic.com/source/xld.....html#counting

Mike

"Zakynthos" wrote:

I want to COUNT (not sum) all the cells in a column that are formatted in RED.

What function/formula can I use for this?

Counting all cells with red font in Excel
 

MIke,

Many thanks for your help, for the 2nd time today!

"Mike H" wrote:

Counting or summing, have a look he-

http://www.xldynamic.com/source/xld.....html#counting

Mike

"Zakynthos" wrote:

I want to COUNT (not sum) all the cells in a column that are formatted in RED.

What function/formula can I use for this?