Removing 0 from the average with the Formula Column

Hey Everyone! I had run into an issue with the Formula column calculating the 0’s on our board. To fix that issue I spoke with one of our agents who is proficient in excel after checking for a possible solution here. This is what he came up with and it worked to get our numbers where they needed to be. In case anyone else could use it.
image
This turns all of the 0’s into Zeros keeping the formula column from including those in the summary
image

1 Like

Thanks! This is just what I was looking for! I appreciate you sharing!

1 Like