Error in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2971684%22%20slang%3D%22en-US%22%3EError%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2971684%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20figure%20out%20a%20spreadsheet%20that%20is%20totally%20messed%20up.%20Please%20forgive%20my%20ignorance%2C%20but%20in%20order%20for%20a%20SUM%20to%20work%20properly%2C%20doesn't%20it%20have%20to%20have%20more%20than%20one%20cell%20number%20in%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2971684%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2971789%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2971789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220547%22%20target%3D%22_blank%22%3E%40lucysmomma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20obligatory.%20You%20can%20use%20%3DSUM(A1)%20without%20problems%20or%20errors%2C%20although%20it%20makes%20little%20sense.%20A%20more%20common%20use%20would%20be%20something%20like%20%3DSUM(A1%2CA4)%20or%20%3DSUM(A1%3AA4)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2972946%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2972946%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220547%22%20target%3D%22_blank%22%3E%40lucysmomma%3C%2FA%3E....%20SUM(A1)%20might%20make%20sense%20if%20A1%20might%20be%20(non-numeric)%20text%20that%20you%20want%20to%20be%20treated%20as%20zero%20in%20an%20arithmetic%20expression.%26nbsp%3B%20I%20prefer%20to%20use%20N(A1)%2C%20since%20that%20is%20its%20purpose.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESUM(%24A%241%3AA1)%20can%20be%20very%20useful.%26nbsp%3B%26nbsp%3B%20When%20it%20is%20copied%20into%20another%20cell%20to%20the%20right%20and%2For%20down%2C%20the%20range%20is%20automagically%20extended.%26nbsp%3B%20For%20example%2C%20as%20you%20drag%20the%20formula%20down%20the%20column%2C%20the%20reference%20becomes%20SUM(%24A%241%3AA2)%2C%20SUM(%24A%241%3AA3)%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20having%20trouble%20figuring%20out%20some%20problems%2C%20I%20suggest%20that%20you%20attach%20an%20example%20Excel%20file%20and%20describe%20the%20problems%20so%20that%20we%20might%20be%20able%20to%20help%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I am trying to figure out a spreadsheet that is totally messed up. Please forgive my ignorance, but in order for a SUM to work properly, doesn't it have to have more than one cell number in it?

2 Replies

@lucysmomma 

That's not obligatory. You can use =SUM(A1) without problems or errors, although it makes little sense. A more common use would be something like =SUM(A1,A4) or =SUM(A1:A4)

@lucysmomma.... SUM(A1) might make sense if A1 might be text that you want to be treated as zero in an arithmetic expression.  I prefer to use N(A1), since that is its purpose.

 

SUM($A$1:A1) can be very useful.   When it is copied into another cell to the right and/or down, the range is automagically extended.  For example, as you drag the formula down the column, the reference becomes SUM($A$1:A2), SUM($A$1:A3), etc.

 

If you are having trouble figuring out some problems, I suggest that you attach an example Excel file and describe the problems so that we might be able to help you.