Mostly For Me But You Can Watch
Auto adjust cells to fit data
cntl + a then while holding alt type hoi
Average and ignore zero cells:=AVERAGEIF(B7:M7,"<>0")
On my old Predator 17 My Ryzen 5 at the office