countif formula

[Guest]

Would like to count the cells in a column that are filled with a color (
yellow in this case). The cells have other values for other formulas but want
to count the color filled cells.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html

 

[Bob Phillips]

oops, wrong page, see Frank's response.

--

HTH

RP
(remove nothere from the email address if mailing direct)