I obviously have something not correct in this formula.
I am trying to get an average of the cells above but only if they have a number in them, the cells represent the months of the year so I am trying to get what should be Jan - April / 4 and not Jan - April / 12.
I used google to try and work it out but I dont understand what I am doing wrong.
SUMIF(D24,F24,H24,J24,L24,N24,P24,R24,T24,V24,X24,Z24)/(SUMPRODUCT((D24,F24,H24,J24,L24,N24,P24,R24,T24,V24,X24,Z24<>0)*1))
Bookmarks