M
Mike McLellan
Hi,
I have a spreadsheet where the rows are labelled in a repeating sequence
Mon, Tue, Wed, Thu, Fri - the first row (Mon) is 118 and the last row (Fri)
is 1007. There are then a number of columns (C thru T) with numeric values
relating to each respective weekday. I want an expression that will allow me
to average the non zero entries for each weekday. Having read other posts, I
tried
=AVERAGE(IF(MOD(ROW(C$118:C$1007),5)=0,IF(C$118:C$1007>0,C$118:C$1007))) but
the results don't look right - can anyone spot where I'm going wrong?
I have a spreadsheet where the rows are labelled in a repeating sequence
Mon, Tue, Wed, Thu, Fri - the first row (Mon) is 118 and the last row (Fri)
is 1007. There are then a number of columns (C thru T) with numeric values
relating to each respective weekday. I want an expression that will allow me
to average the non zero entries for each weekday. Having read other posts, I
tried
=AVERAGE(IF(MOD(ROW(C$118:C$1007),5)=0,IF(C$118:C$1007>0,C$118:C$1007))) but
the results don't look right - can anyone spot where I'm going wrong?