I'm trying to find the average of a series of cells in the same
column, only problem is I'm having trouble concatenating the row
number and column into the AVERAGE function, such that I need to do
something like =AVERAGE(IF(E1:E20,E1:E2))/10, where the values I'm
interested in are always in column E, but the range of rows vary. I
can implement a search so the beginning and ending row numbers are in
variables, but how would I concatenate the "E" and the row numbers so
the AVERAGE function will work?

Hi
See help with INDIRECT function
=AVERAGE(IF(INDIRECT("E:E" & Rw)0 ....

HTH
Cordially
Pascal

"ucsdtritons" a écrit dans le message de
om...
I'm trying to find the average of a series of cells in the same
column, only problem is I'm having trouble concatenating the row
number and column into the AVERAGE function, such that I need to do
something like =AVERAGE(IF(E1:E20,E1:E2))/10, where the values I'm
interested in are always in column E, but the range of rows vary. I
can implement a search so the beginning and ending row numbers are in
variables, but how would I concatenate the "E" and the row numbers so
the AVERAGE function will work?