{=AVERAGE(IF(I6:I36<>0,I6:I36,""))}
Above formula gives out "#DIV/0!" value if there is not data (in other words, zero value). Is there a way to modify above formula to get a 0 (zero) or a blank if there is no data (numeric only)?
Thank you!
Regards,
Above formula gives out "#DIV/0!" value if there is not data (in other words, zero value). Is there a way to modify above formula to get a 0 (zero) or a blank if there is no data (numeric only)?
Thank you!
Regards,