Page 1 of 1

average column macro

Posted: 2007-07-06 05:17:16
by phspaelti
The macro to average columns states that "empty cells are not counted so they do not affect the average, but cells with a zero in them are counted and they do affect the average".

My tests show me that if the cell contains contains "0." or "0 " the behavior is as specified (i.e., the 0 is included) but a simple "0" without any other characters in the cell is ignored.

Posted: 2007-07-06 13:34:02
by martin
Thanks, I'll file a bug.