COUNTIF FUNCTION
 

What would the sytax be to do a countif() function with a dynamic range? For
instance: =CountIf($H$3:$J$(value of cell A3),"=1")
Thank You very much

COUNTIF FUNCTION
 

You can use the INDIRECT function for this:

=COUNTIF(INDIRECT("H3:J"&$A$3),"=1")

Note that cell references placed in quotes "" within the INDIRECT function
will not increment when the formula is copied, thus no need for absolute
referencing ($). But, since the A3 reference is outside of the quotes, it
will increment if the $ symbols are not present.

HTH,
Elkar


"falcon491" wrote:

What would the sytax be to do a countif() function with a dynamic range? For
instance: =CountIf($H$3:$J$(value of cell A3),"=1")
Thank You very much

COUNTIF FUNCTION
 

Thank You Very Much! Worked Great!!

"Elkar" wrote:

You can use the INDIRECT function for this:

=COUNTIF(INDIRECT("H3:J"&$A$3),"=1")

Note that cell references placed in quotes "" within the INDIRECT function
will not increment when the formula is copied, thus no need for absolute
referencing ($). But, since the A3 reference is outside of the quotes, it
will increment if the $ symbols are not present.

HTH,
Elkar


"falcon491" wrote:

What would the sytax be to do a countif() function with a dynamic range? For
instance: =CountIf($H$3:$J$(value of cell A3),"=1")
Thank You very much