Countifs for color format
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?
.
|