Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
my excel program is not adding up the formulas (eg =SUM(A1:A2)) it is not
adding it up, if anyone could reply it would be helpful thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
"help plz" wrote:
my excel program is not adding up the formulas (eg =SUM(A1:A2)) it is not adding it up, if anyone could reply it would be helpful thank you It sounds like the calc mode's inadvertently set to Manual. Press F9 key, does it now compute properly? To check/change calc mode, click Tools Options Calculation tab Check Auto OK. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
What do you mean, it's not adding it up? Do you get the wrong total, a zero or an error? If it's the wrong total or zero perhaps some of your numbers are text. Try to convert them to numeric or total them with =SUMPRODUCT(--(A1:A10) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=568834 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |