7/13 In Excel, is it possible to average every 24th column in a particular
row. I googled this and found *http://www.exceltip.com/st/Calculating_the_Average_Value_in_Every_Nth_Column,_Excluding_Zeros%09/862.html*
though I can't get it to work. In my spreadsheet, I have
=AVERAGE(IF((MOD(COLUMN(C156:CP156)-CELL("col",C156),24)=0),C156:CP156))
It makes sense, but won't work. It seems to do the if logic only
on the first column, and then just average the entire range, rather
than the 1st, 25th, 49th columns, etc. |