I have the following formulas which I have worked out =AVERAGEIF('2020'!J2:NW117,C1,'2020'!NW2:NW117), however I need it now to exclude any "0" in the calculation range.
I have tried many different ways but to no avail, any help would be much appreciated
Thank you
Bookmarks