Summing adjacent cells: another cell added to formula! 
Author Message
 Summing adjacent cells: another cell added to formula!

Excel 2000 (v. 9.0.2720)

This is such an obvious bug that it's almost unbelievable.  Tell me I'm doing
something wrong.

The formula in cell I5 is

=D5+E5+F5+G5

Cells D5 through G5 are to be entered with numerical data (or any of them may
be left blank), as is cell H5.  (But note that H5 is not included in the
formula in cell I5.)

Under certain circumstances, e.g., if all four cells from D5 through G5 happen
to be entered with numerical data, with H5 also getting an entry, the formula
in cell I5 arbitrarily changes to:

=D5+E5+F5+G5+H5

This is the case with other variants of the formula (e.g., =SUM(D5:G5)) as
well.

One workaround is to insert a blank column between columns G and H, to break
the "sequence".  

Anyway, does Microsoft have a patch to correct this?  Again, it's such a
blatantly basic, but serious, error for a worksheet, that it's unbelievable.
(Or, is it some supposed form of "automation" gone awry??)

Thanks for any help.

Jay



Thu, 27 Feb 2003 01:58:28 GMT  
 Summing adjacent cells: another cell added to formula!
Hi Jay,

Tools>Options>Edit, uncheck Extend list formats and formulas

Groeten,

Niek Otten



Quote:
> Excel 2000 (v. 9.0.2720)

> This is such an obvious bug that it's almost unbelievable.  Tell me I'm
doing
> something wrong.

> The formula in cell I5 is

> =D5+E5+F5+G5

> Cells D5 through G5 are to be entered with numerical data (or any of them
may
> be left blank), as is cell H5.  (But note that H5 is not included in the
> formula in cell I5.)

> Under certain circumstances, e.g., if all four cells from D5 through G5
happen
> to be entered with numerical data, with H5 also getting an entry, the
formula
> in cell I5 arbitrarily changes to:

> =D5+E5+F5+G5+H5

> This is the case with other variants of the formula (e.g., =SUM(D5:G5)) as
> well.

> One workaround is to insert a blank column between columns G and H, to
break
> the "sequence".

> Anyway, does Microsoft have a patch to correct this?  Again, it's such a
> blatantly basic, but serious, error for a worksheet, that it's
unbelievable.
> (Or, is it some supposed form of "automation" gone awry??)

> Thanks for any help.

> Jay



Thu, 27 Feb 2003 02:09:14 GMT  
 Summing adjacent cells: another cell added to formula!
Niek:

Quote:
>Tools>Options>Edit, uncheck Extend list formats and formulas

Thanks.  What a relief!

Jay



Thu, 27 Feb 2003 02:44:36 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Summing using formulas already in cells, not cell references, or values in cells

2. sum of non-adjacent cells

3. Cell formula to add all BOLD Cells?

4. Excel cell text overwriting adjacent cells

5. how to stop a cell from bleeding into adjacent cells

6. The Tab Key jumps several cells, and not adjacent cells

7. Cell contents spillover to adjacent cells

8. move active cell to non-adjacent cell

9. Converting Date in a cell (8/01/02) to Weekday (Thursday) in an adjacent cell

10. counting adjacent cells when a cell holds a particular value


 
Powered by phpBB® Forum Software © phpBB Group