#value problem + text to formula
 

I keep getting a #value when I enter

=VALUE(CONCATENATE("=power(countif(c$3:c$",(VALUE( AL3)),",$af3),1)"))

C$3 = 3
AL3 = 12
$af3 = 1

I'm using excel2007 beta2, and cannot get the
Find & Select Replace
the " with NOTHING when I use
CONCATENATE("=countif(c$3:c$",(VALUE(AL3)),",$af3) ")

I'm tring to have the text turn into this formula
=countif(c$3:c$12,$af3)
and then give a value.

I don't know anything about micro and at best a novice at excel.
Please HELP!!!

#value problem + text to formula
 

Try
=COUNTIF(INDIRECT("C$3:C$"&$AL3),$AF3)


You do know that POWER(X,1) is always X?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"trav2016" wrote in message
...
I keep getting a #value when I enter

=VALUE(CONCATENATE("=power(countif(c$3:c$",(VALUE( AL3)),",$af3),1)"))

C$3 = 3
AL3 = 12
$af3 = 1

I'm using excel2007 beta2, and cannot get the
Find & Select Replace
the " with NOTHING when I use
CONCATENATE("=countif(c$3:c$",(VALUE(AL3)),",$af3) ")

I'm tring to have the text turn into this formula
=countif(c$3:c$12,$af3)
and then give a value.

I don't know anything about micro and at best a novice at excel.
Please HELP!!!

#value problem + text to formula
 

You can't "build" a formula like that. CONCATENATE is a TEXT function. It's
output is TEXT. Maybe this is what you're after:

=COUNTIF(INDIRECT("C3:C"&AL3),AF3)

Biff

"trav2016" wrote in message
...
I keep getting a #value when I enter

=VALUE(CONCATENATE("=power(countif(c$3:c$",(VALUE( AL3)),",$af3),1)"))

C$3 = 3
AL3 = 12
$af3 = 1

I'm using excel2007 beta2, and cannot get the
Find & Select Replace
the " with NOTHING when I use
CONCATENATE("=countif(c$3:c$",(VALUE(AL3)),",$af3) ")

I'm tring to have the text turn into this formula
=countif(c$3:c$12,$af3)
and then give a value.

I don't know anything about micro and at best a novice at excel.
Please HELP!!!

#value problem + text to formula
 

In , Biff
spake thusly:

You can't "build" a formula like that. CONCATENATE is a TEXT
function. It's output is TEXT. Maybe this is what you're after:

On the other hand, Laurent Longre's "Morefunc" Add-In set at
http://xcell05.free.fr/ does inclue an EVAL function, which would
work as the OP would like.

-- dman

--------------------------------------------
=COUNTIF(INDIRECT("C3:C"&AL3),AF3)

Biff

"trav2016" wrote in message
...
I keep getting a #value when I enter

=VALUE(CONCATENATE("=power(countif(c$3:c$",(VALUE( AL3)),",$af3),1)"))

C$3 = 3
AL3 = 12
$af3 = 1

I'm using excel2007 beta2, and cannot get the
Find & Select Replace
the " with NOTHING when I use
CONCATENATE("=countif(c$3:c$",(VALUE(AL3)),",$af3) ")

I'm tring to have the text turn into this formula
=countif(c$3:c$12,$af3)
and then give a value.

I don't know anything about micro and at best a novice at excel.
Please HELP!!!

#value problem + text to formula
 

Yes I know about power but I needed to change the power for other columns.
BIG, Thank you to all.