Concatenation in a CountIf

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

Guest

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(INDIRECT("K13:K"&A4),"1")


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Would this work for you?:
=COUNTIF(INDIRECT("K13:K"&$A$4),"1")

••••••••••
Regards,
Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenation Setback 4
Excel Need Countifs Formula Help 0
Lose the 0 in the Total cell 6
Concatenated formula help 3
Countif problem 2
countif on cells with formula's won't work correctly 21
INDIRECT !@%? 2
Countif with a Range of criteria 8

Back
Top