Auto adjust cells to fit data
cntl + a then while holding alt type hoi
Average and ignore zero cells:
=AVERAGEIF(B7:M7,"<>0")
After the mess I made in previous posts this summary might be useful. Thanks PatchMyPC, the great and powerful program downloader and up...