Average Non-Adjacent Cells in Budget Spreadsheet
OPB3 wrote:
This is close but it only works on on rows (AH7, AH8, etc) without my
subtotals (AH9). I have attached a pdf of the spreadsheet (I Think) and
this is the actual formula:
=(J7+L7+N7+P7+R7+T7+V7+X7+Z7+AB7+AD7+AF7)/(COUNTA(J7,L7,N7,P7,R7,T7,V7,X7,Z7,AB7,AD7,AF7))
The row with the subtotal has a zero placed due to the formula so the
future months that have no actuals skew the average. The AVERAGE
function alone, as suggested, does not work at all.
[...]
Given the structure of the formula you posted:
=AVERAGE(IF(MOD(COLUMN(J7:AF7)-COLUMN(J7)+0,2)=0,IF(J7:AF70),J7:AF7)))
which needs to be confirmed with control+shift+enter, not just with enter.
|