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? |
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? |
All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com