Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula To Ignore Zeros In Averages?
I have columns running left to right with the 12 months listed as the main header of each. I want to have a column on the far right that shows our average month's sales based on each months totals we go. RIght now it is May, but the simple AVG formula also counts June-December sicne they have zeros in them. So, instead of it dividing the total by 5, it is dividing by 12, thus giving a false average. I already understand that I can simply delete the zeros. However, those zeros are there based on the formula with that cell which will total that column's sales totals based on the cells below (Children).
In short, I just need a way to tell the formula to ignore anything showing a zero and then divided by the cells containg actual sales numbers.
So, what would you add to this is formula below to accomplish this?