Concatenation in a CountIf
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 |
Concatenation in a CountIf
=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 |
Concatenation in a CountIf
=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 |
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 |
Concatenation in a CountIf
Have a look at INDIRECT
eg. =COUNTIF(INDIRECT("K13:K"&A4),"1") hth RES |
All times are GMT +1. The time now is 01:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com