U
ucsdtritons
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:E2>0,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?
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:E2>0,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?