| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with SUM()
Greetings from Norfolk
This may be a silly question! I set up SUM(D5:D10) and put the result in D15. When trying out the sheet I made entries (numeric) in D5, D6...D10 all OK. I then made entries in D11, D12, D13 and D14; The formulae in D15 modified itself (!!??) to include these values in the Summation. i.e. the answer was progressively D5 to D10, D5 to D11, D5 to D12 etc. Can anybody explain and assist in preventing this occuring again. Ilooked through the various settings for Excel, but could not find any that appear relevant ! -- Richard. "I have yet to see any problem, however complicated, which when looked at in the right way, did not become still more complicated" Poul Anderson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
