After putting the three functions into a module, when I reset the value in
the column it says "Ambiguous name detected: CountOfCF"


--
Thank you!


"Gord Dibben" wrote:

You need to copy more than one function from Chip's site.

Getstrippedvalue

Activecondition

Countofcf

Place these in a general module in your workbook.

All of this may be unnecessary.

Can't you just count by condition rather than color?

In Z1 enter =AVERAGE(AA3:AK3)

Then in another =COUNTIF($AA3:$AK3"Z1")


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 10:15:01 -0800, Doug
wrote:

Do I place the Function GetStrippedValue in the sheet view code? I have
placed it in the view code and entered =CountOfCF($AA3:$AK3,2) to show number
of green filled and it shows #name.

I noticed that Pearson says:
NOTE: ActiveCondition may result in an inaccurate result if the following
are true:

* You are calling ActiveCondtion from a worksheet cell, AND
* The cell passed to ActiveCondtion uses a "Formula Is" rather than
"Cell Value Is" condition, AND
* The formula used in the condition formula contains relative addresses

The formula I am using is "above average" for columns AA Through AK.

Is this why it is not working?

.