Variating Rows in column - Microsoft Community

how can have function change based on given number of rows type in cell average.  example, set 20 rows from e8 down thru e27, if change number 25 need =average(e8:e32).  have other functions apply logic if can tell me how example.  thank much!  example lets variable placed above in cell e6.

=average(e8:e27)

hi dak,

how can have function change based on given number of rows type in cell average.  example, set 20 rows from e8 down thru e27, if change number 25 need =average(e8:e32).  have other functions apply logic if can tell me how example.  thank much!  example lets variable placed above in cell e6.

=average(e8:e27)

assume number of rows entered in cell a1, try:

     =average(offset(e8,0,0,a1,1))

===

regards,

norman

Office / Excel / Windows 8 / Office 2013