No, that didn't work. Now it's counting everytime it sees an "11"

"pinmaster" wrote:

Hi,

I'm not really fimiliar with UDF's but should work with SUMPRODUCT, try:

=SUMPRODUCT((ASAPCountByFontColor(E5:E17,3))*(E5:E 17=11))

HTH
Jean-Guy

"Help" wrote:

I am trying to count and cells that have a number "11" in the cell and is
colored red.
The following formula, will count all cells that are red... but I only want
it to look at the cells with the "11". How do I do that?

=ASAPCountByFontColor(E5:E17,3)

Jane.