Hi all,
I have a fixed range to an average formula (=IFERROR(AVERAGE(J12:BB12),"<LOD")).
The cells included in the range (J12:BB12) all contain lookup formulas which lookup data from another sheet. The lookup formula returns numbers greater than 0.0001 where data is present. Where there is no data/value to be returned '0' is shown. I need my average calculation to work out the average of the lookup values but not including the '0' where no data has been looked-up. All the extra zeros are bringing my averages down significantly.
Thanks
Bookmarks