| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not working
Using Microsoft Excell 2000
Have a worksheet with numbers in column E, cells E3 to E10. In cell E12, have the formula =SUM(E3:E10). Used the AutoSum key to generate the formula and typed it in manually. No matter, the answer I get is the value in Cell E10. Can only get the right total if I type the formula as =E3+E4+E5+E6+E7+E8+E9+E10. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula not working
Maybe the numbers in E3:E9 are being recognized as text values. Try the
following... 1) Select an empty cell 2) Edit Copy 3) Select E3:E9 4) Edit Paste Special Add Ok In article , Cinderella wrote: Using Microsoft Excell 2000 Have a worksheet with numbers in column E, cells E3 to E10. In cell E12, have the formula =SUM(E3:E10). Used the AutoSum key to generate the formula and typed it in manually. No matter, the answer I get is the value in Cell E10. Can only get the right total if I type the formula as =E3+E4+E5+E6+E7+E8+E9+E10. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
| Formula entered not working | Excel Discussion (Misc queries) | |||
Linear Mode
