COUNTIF FUNCTION

F

falcon491

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
 
E

Elkar

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
 
F

falcon491

Thank You Very Much! Worked Great!!

Elkar said:
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
Click to expand...
 
Top