Count a Range, but only those cells with Black font Q

[Sean]

I have the formula below that counts the number of instances of the
value held in A43 that appears in the range D9:AG35, but how could I
also include the qualifier thatonly count the number of these values
that are in Black font? Is this possible?

=COUNTIF($D$9:$AG$35,A43)

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)