Hello I am pretty inexperienced with iWork apps but thanks to my experience with Office suite I usually figure out things pretty quickly. I am trying to figure out how to average the sums in this table: Header row represents time as in months. I want to put numbers under each month. The sum row (green) will simply add these numbers up. So far everything works good, I highlighted each column and selected "Sum function" which adds up neatly in Sum row. Now if I use "Average function" on the sum row it does not work as I want it to work. It does not ignore zero, see this example: My "Average" cell has this formula: You can see that the Average row differs from what is on the calculator. I put the three numbers in calculator and divided them by three. Formula in Average row seems to constantly divide everything by six (there are six "Sum cells"). What I want to do basically is for the formula to ignore the zero because calculations are not correct. I know I could probably define Average for each column but I want it to be more flexible because I might be adding columns in the future. That is why I think averaging Sum row is easier. Maybe I'm doing everything wrong, I've always been really bad at math so apologies.