software

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 quot;15quot; and quot;30quot; to
make the formula above dynamic. My dream is to input row numbers
(range) into cells A1 and A2 and then reference the quot;VALUESquot; of these
cells in the formula above. Basically, I don't want to hard code quot;15quot;
and quot;30quot; into the formula above.

Any suggestions? Thanks!--
jcottam
------------------------------------------------------------------------
jcottam's Profile: www.excelforum.com/member.php...oamp;userid=33049
View this thread: www.excelforum.com/showthread...hreadid=528643=COUNTIF(INDIRECT(quot;DataWorkSheet!L$quot;amp;A1amp;quot;:L$quot;amp;A2amp;quot; ,$A16quot;))/$B$10
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jcottamquot; gt; wrote in
message ...
gt;
gt; Hi There,
gt;
gt; I'm looking to make a worksheet as dynamic as possible.
gt;
gt; I want to define a range of ROWS (rows 15 - 30) in table cells (ex: A1=
gt; 15 , A2= 30)
gt;
gt; I then want to reference these definitions in a formula like the one
gt; below:
gt;
gt; =SUM(COUNTIF(DataWorkSheet!L$*15*:L$*30*,$A16)/$B$10)
gt;
gt; Unfortunately I don't know how to reference variables quot;15quot; and quot;30quot; to
gt; make the formula above dynamic. My dream is to input row numbers
gt; (range) into cells A1 and A2 and then reference the quot;VALUESquot; of these
gt; cells in the formula above. Basically, I don't want to hard code quot;15quot;
gt; and quot;30quot; into the formula above.
gt;
gt; Any suggestions? Thanks!
gt;
gt;
gt; --
gt; jcottam
gt; ------------------------------------------------------------------------
gt; jcottam's Profile:
www.excelforum.com/member.php...oamp;userid=33049
gt; View this thread: www.excelforum.com/showthread...hreadid=528643
gt;

Thanks !! : )--
jcottam
------------------------------------------------------------------------
jcottam's Profile: www.excelforum.com/member.php...oamp;userid=33049
View this thread: www.excelforum.com/showthread...hreadid=528643