hi there. input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand. i'm guessing:
=AVERAGEIF(B2:Q2,"<>0")