Hi There,

I'm looking to make a worksheet as dynamic as possible.

I want to define a range of ROWS (rows 15 - 30) in table cells (ex: A1=
15 , A2= 30)

I then want to reference these definitions in a formula like the one
below:

=SUM(COUNTIF(DataWorkSheet!L$*15*:L$*30*,$A16)/$B$10)

Unfortunately I don't know how to reference variables "15" and "30" to
make the formula above dynamic. My dream is to input row numbers
(range) into cells A1 and A2 and then reference the "VALUES" of these
cells in the formula above. Basically, I don't want to hard code "15"
and "30" into the formula above.

Any suggestions? Thanks!


--
jcottam
------------------------------------------------------------------------
jcottam's Profile: http://www.excelforum.com/member.php...o&userid=33049
View this thread: http://www.excelforum.com/showthread...hreadid=528643

=COUNTIF(INDIRECT("DataWorkSheet!L$"&A1&":L$"&A2&" ,$A16"))/$B$10



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jcottam" wrote in
message ...

Hi There,

I'm looking to make a worksheet as dynamic as possible.

I want to define a range of ROWS (rows 15 - 30) in table cells (ex: A1=
15 , A2= 30)

I then want to reference these definitions in a formula like the one
below:

=SUM(COUNTIF(DataWorkSheet!L$*15*:L$*30*,$A16)/$B$10)

Unfortunately I don't know how to reference variables "15" and "30" to
make the formula above dynamic. My dream is to input row numbers
(range) into cells A1 and A2 and then reference the "VALUES" of these
cells in the formula above. Basically, I don't want to hard code "15"
and "30" into the formula above.

Any suggestions? Thanks!


--
jcottam
------------------------------------------------------------------------
jcottam's Profile:
http://www.excelforum.com/member.php...o&userid=33049
View this thread: http://www.excelforum.com/showthread...hreadid=528643

Thanks !! : )


--
jcottam
------------------------------------------------------------------------
jcottam's Profile: http://www.excelforum.com/member.php...o&userid=33049
View this thread: http://www.excelforum.com/showthread...hreadid=528643