I am trying to calculate a averaged at a row level, based on data within three columns. Sometimes data in the row my be zero and I want to exclude that from the average calculation. What is the best way to do this? Attached a picture of the data set
Here is another approach that will get you to the same place with this data set. If you are going to be adding seasons later you would have to tweak the formula. The previous reply is a better option to keep it dynamic for that.