I have a formula that returns a number in cell A4.
Another formula in cell K2, =COUNTIF(K13:K301,"1").
From the result in cell A4, is there a way to concatenate that into the
section of K2s formula replacing the 301 with A4s result?

Stumped by syntax,
Arturo

=COUNTIF(INDIRECT("K13:K"&A4),"1")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Arturo" wrote in message
...
I have a formula that returns a number in cell A4.
Another formula in cell K2, =COUNTIF(K13:K301,"1").
From the result in cell A4, is there a way to concatenate that into the
section of K2's formula replacing the 301 with A4's result?

Stumped by syntax,
Arturo

=COUNTIF(K13:INDIRECT("K"&A4),1)


--

Regards,

Peo Sjoblom

"Arturo" wrote in message
...
I have a formula that returns a number in cell A4.
Another formula in cell K2, =COUNTIF(K13:K301,"1").
From the result in cell A4, is there a way to concatenate that into the
section of K2's formula replacing the 301 with A4's result?

Stumped by syntax,
Arturo

Would this work for you?:
=COUNTIF(INDIRECT("K13:K"&$A$4),"1")

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Arturo" wrote:

I have a formula that returns a number in cell A4.
Another formula in cell K2, =COUNTIF(K13:K301,"1").
From the result in cell A4, is there a way to concatenate that into the
section of K2s formula replacing the 301 with A4s result?

Stumped by syntax,
Arturo

Have a look at INDIRECT

eg. =COUNTIF(INDIRECT("K13:K"&A4),"1")

hth RES