ok so lets start with a simple sum product

=SUMPRODUCT($G3:I3,$G4:I4) <--simple sum product 2 different rows keeping the starting point the same.

Lets flip the second row and make it do things in reverse. simple enough (ok not so much)

=SUMPRODUCT($G3:I3,N(OFFSET($G4:I4,0,COLUMNS($G4:I4)-COLUMN($G4:I4)+CELL("Col",$G4:I4)-1)))/SUM($G3:I3)

NOW comes the kicker, lets make it only consider non zero values.... (get ready! )

=SUMPRODUCT(IF($G17:I17,$G17:I17),IF(N(OFFSET($G18:I18,0,COLUMNS($G18:I18)-COLUMN($G18:I18)+CELL("Col",$G18:I18)-1)),N(OFFSET($G18:I18,0,COLUMNS($G18:I18)-COLUMN($G18:I18)+CELL("Col",$G18:I18)-1))))/SUM(IF($G17:I17,$G17:I17))

it's not working

Basically =AVERAGE(IF(A3:A5,A3:A5)) will only average non zero values. That's what I am trying to do but I am not doing it right...

1) is there an simpler way to do this? I can't sit there explaining this horrible horrible formula

2) can you proof read it and see where I am going wrong?