On Monday, November 29, 1999 at 8:00:00 AM UTC, Nigel wrote:
Hi!
I'd like to use =sum(above) but I discovered
that if one of the cell above is blank, the formulae
doesn't work, and I have to insert zero b4 it do.
Anyway to make it works w/o inserting zero?
Thanks!!
Nigel
Create an extra small column, and merge the 2 cells at the bottom, like this:
+-----------------+--+-------+
| item 1 | | 100 |
+-----------------+--+-------+
| item 2 | | |
+-----------------+--+-------+
| item 3 | | 200 |
+-----------------+--+-------+
| Total | 300 | <- =SUM(C:C)
+-----------------+----------+
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)