Forum Discussion
Calculating averages (percents) within a date range. Answer come back #DIV/0.
Calculating average percent complete for construction activities. If the activities are not applicable I enter N/A. If all the activities are N/A, the average result comes back as #DIV/0? I would lik...
Also, you can use this formula instead:
=IF(COUNT(B1:B3)=0,0,AVERAGE(B1:B3))