Posts by FlameRetired

    Re: Calculate average for specified numbers from a column


    Another way.


    Array entered


    Code
    =AVERAGE(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2:A5,";",REPT(" ",256),3),";",REPT(" ",256),2),256,256)))

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. (CSE for short.)