COUNTIF FUNCTION

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank You Very Much! Worked Great!!

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