Concatenation in a CountIf
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
|