Morning All,
I am using the below formula to calculate an average:
=AVERAGE(Data!H2:H1000)
The problem I have is that the data range contains zero's which effect the average, is there anyway to exclude zero's and only count an average for anything greater than zero?
Regards,
Matt