| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum func. is adding cells not in specified range
the function is simple
=Sum(B5:B22) when ever I type data in to cells B23 or B24 the formula changes to =Sum(B5:B23) or =Sum(B5:B24). What's going on with this thing |
|
#2
|
|||
|
|||
|
Hi,
To turn this off: On the Tools menu, click Options, and then click the Edit tab. Do one of the following: Deselect the Extend list formats and formulas check box. Thanks, Matt "Big Daddy" wrote: the function is simple =Sum(B5:B22) when ever I type data in to cells B23 or B24 the formula changes to =Sum(B5:B23) or =Sum(B5:B24). What's going on with this thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Linear Mode
