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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 13 Mar 2008 22:06 GMT

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)

Reply to this Message

Bob Phillips - 13 Mar 2008 22:55 GMT

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

Signature

---
HTH

Bob

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

>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)

Reply to this Message