# Re: All hail Neo!

From: Marshall Spight <marshall.spight_at_gmail.com>

Date: 26 Apr 2006 13:30:16 -0700

Message-ID: <1146083416.518617.324390_at_i40g2000cwc.googlegroups.com>

Date: 26 Apr 2006 13:30:16 -0700

Message-ID: <1146083416.518617.324390_at_i40g2000cwc.googlegroups.com>

David Cressey wrote:

> "Marshall Spight" <marshall.spight_at_gmail.com> wrote in message

*> >
**> > I just fired up Excel 2003. I entered two columns of numbers, and
**> > left one cell empty in each column. Then I set the formula for the
**> > third column to be col1 + col2. Then I got the sum of the first two
**> > column. It behaved exactly as I propose: missing values were
**> > ignored, both on the vertical sum and on the horizontal sum.
**> > This preserves the SUM(A) + SUM(B) = SUM(A+B) property
**> > as well.
**>
**> Repeat the experiment with avg. The results are even more interesting than
**> sum.
*

Marshall Received on Wed Apr 26 2006 - 22:30:16 CEST