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=528653Try taking a look at INDIRECT for building a reference from a string, or
perhaps OFFSET to build a range from values in a cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------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:
gt; www.excelforum.com/member.php...oamp;userid=33049
gt; View this thread: www.excelforum.com/showthread...hreadid=528653
gt;