Interesting, but the =AVG() and I suspect other functions might have a flaw. When I tried =AVG(B1:B4), with one value in B1 (6), it returned 1.5 as the average.

Interesting, but the =AVG() and I suspect other functions might have a flaw. When I tried =AVG(B1:B4), with one value in B1 (6), it returned 1.5 as the average. edit: ah, just AVG() then, the scroll didn't work on my first try so I assumed it only showed SUM() and AVG() was just a "hidden" function.