Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I would like to set the average column equal to average of column(3) (ie $677.59), kindly advise how to write the formula.
Thank you
Tracy
Dear Frank_Hartmann
Many thanks for your quick response.
Kindly advise why avg (total column(3)) is not working as it is the same as avg(total Price*Quantity).
Also, how to make avg(total column(3)) work, am I missing anything ?
Thank you
Tracy