#value problem + text to formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
Try
=COUNTIF(INDIRECT("C$3:C$"&$AL3),$AF3)


You do know that POWER(X,1) is always X?
best wishes
 
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
 
Biff said:
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:
Click to expand...

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

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