I've got an expanding table (rows can be added) and I'm trying to use the footer row of the column to compute the average of cells that don't have a value of 0.
Form Calc is usually great, but in this instance, I need to divide the sum by the number of cells that are not zero and I'm not sure how to do that via Form Calc.
Now it's just the numerator. It's got to be a loop, right?
Table is called: table1
Row is called: data
cell is called: eValue
Any thoughts? Or more efficient methods? Thanks so much.