On 07/31/10 13:09, James wrote: > I want the average of all the non-empty cells in a column 'c' starting > at row 3. > I tried: > =AVERAGE(C3:c$(count(C3:C51)+3)) > > I'm sure it is simple. > I need to make c$(count(C3:C51)+3) a cell reference. > 'c15' as a non-formula, count(C3:C51)+3 = 15.
Found the solution:
*=AVERAGE(C3:INDIRECT("c"&(COUNT(C3:C51)+3)))*
