Hello... I am new to this forum sit. Not sure where to post my question. Or where to get any responses.. Total newbie. I am trying to figure out a formula on Numbers to get the average value of a column. I have a value for everyday of the month 1-31. The problem I am running into is on some days the value is zero and I don't want any days with a zero value equated into my monthly average..does that make sense? I appreciate any help. I may have posted this twice.. sorry.. I couldn't find it on the board the first time..