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



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Exchange Mail Defer Reason: LED=450 4.4.318 Connection was - Microsoft Community