Home

Tried every which way to get rid of Value! - anyone willing to help me?

%3CLINGO-SUB%20id%3D%22lingo-sub-613901%22%20slang%3D%22en-US%22%3ETried%20every%20which%20way%20to%20get%20rid%20of%20Value!%20-%20anyone%20willing%20to%20help%20me%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-613901%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%20and%20Gals%2C%3C%2FP%3E%3CP%3EGetting%20frustrated%20so%20hoping%20someone%20more%20figures%2Fexcel%20orientated%20that%20I%20might%20be%20able%20to%20help.%20Keep%20on%20getting%20the%20Value!%20sign%20when%20I'm%20adding%20up%20a%20whole%20load%20of%20figures%20adding%20together%20(they're%20receipts).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20my%20sum%20below%20which%20%3D%20Value!%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%20Have%20I%20put%20something%20extra%20in%20or%20added%20something%3F%3C%2FP%3E%3CP%3EI've%20gone%20up%20and%20down%20the%20list%20x6%20times%20to%20check%20they%20are%20all%20in%20the%20correct%20places%20and%20no%20hidden%20extras.%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20I'm%20adding%202%20columns%20(card%20%2B%20cash%20columns)%3C%2FP%3E%3CP%3EI%20had%20thought%20blocking%20sections%20together%20e.g.%20E4%3AE20%20would%20help%20to%20reduce%20the%20length%20of%20the%20sum.%20However%20is%20the%20problem%20because%20I'm%20mixing%20this%20with%20adding%20up%3F%20Or%20is%20that%20ok%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUM(%3CSPAN%3EE263%3C%2FSPAN%3E%2B%3CSPAN%3EF266%3C%2FSPAN%3E%2B%3CSPAN%3EF264%3C%2FSPAN%3E%2B%3CSPAN%3EE258%3C%2FSPAN%3E%2B%3CSPAN%3EE256%3C%2FSPAN%3E%2B%3CSPAN%3EE23%3C%2FSPAN%3E%2B%3CSPAN%3EF241%3C%2FSPAN%3E%2B%3CSPAN%3EF240%3C%2FSPAN%3E%2B%3CSPAN%3EE234%3C%2FSPAN%3E%2B%3CSPAN%3EF221%3C%2FSPAN%3E%2B%3CSPAN%3EF220%3C%2FSPAN%3E%2B%3CSPAN%3EF213%3C%2FSPAN%3E%2B%3CSPAN%3EF152%3C%2FSPAN%3E%2B%3CSPAN%3EE217%3C%2FSPAN%3E%2B%3CSPAN%3EE210%3C%2FSPAN%3E%2B%3CSPAN%3EF209%3C%2FSPAN%3E%2B%3CSPAN%3EF208%3C%2FSPAN%3E%2B%3CSPAN%3EE201%3C%2FSPAN%3E%2B%3CSPAN%3EE200%3C%2FSPAN%3E%2B%3CSPAN%3EE194%3C%2FSPAN%3E%2B%3CSPAN%3EE193%3C%2FSPAN%3E%2B%3CSPAN%3EF12%3C%2FSPAN%3E%2B%3CSPAN%3EF164%3AF174%3C%2FSPAN%3E%2B%3CSPAN%3EE163%3C%2FSPAN%3E%2B%3CSPAN%3EF162%3C%2FSPAN%3E%2B%3CSPAN%3EF157%3C%2FSPAN%3E%2B%3CSPAN%3EF156%3C%2FSPAN%3E%2B%3CSPAN%3EF154%3C%2FSPAN%3E%2B%3CSPAN%3EE129%3C%2FSPAN%3E%2B%3CSPAN%3EF145%3C%2FSPAN%3E%2B%3CSPAN%3EF124%3AF128%3C%2FSPAN%3E%2B%3CSPAN%3EF130%3AF145%3C%2FSPAN%3E%2B%3CSPAN%3EF114%3AF122%3C%2FSPAN%3E%2B%3CSPAN%3EE113%3C%2FSPAN%3E%2B%3CSPAN%3EF109%3AF110%3C%2FSPAN%3E%2B%3CSPAN%3EF90%3AF94%3C%2FSPAN%3E%2B%3CSPAN%3EF96%3AF104%3C%2FSPAN%3E%2B%3CSPAN%3EE87%3C%2FSPAN%3E%2B%3CSPAN%3EF81%3AF83%3C%2FSPAN%3E%2B%3CSPAN%3EF61%3AF75%3C%2FSPAN%3E%2B%3CSPAN%3EF56%3C%2FSPAN%3E%2B%3CSPAN%3EF45%3C%2FSPAN%3E%2B%3CSPAN%3EF44%3C%2FSPAN%3E%2B%3CSPAN%3EF23%3C%2FSPAN%3E%2B%3CSPAN%3EF162%3AF174%3C%2FSPAN%3E%2B%3CSPAN%3EE150%3C%2FSPAN%3E%2B%3CSPAN%3EE147%3C%2FSPAN%3E%2B%3CSPAN%3EF110%3C%2FSPAN%3E%2B%3CSPAN%3EF96%3AF104%3C%2FSPAN%3E%2B%3CSPAN%3EF90%3AF94%3C%2FSPAN%3E%2B%3CSPAN%3EE76%3C%2FSPAN%3E%2B%3CSPAN%3EF61%3AF75%3C%2FSPAN%3E%2B%3CSPAN%3EF58%3AF59%3C%2FSPAN%3E%2B%3CSPAN%3EF53%3AF56%3C%2FSPAN%3E%2B%3CSPAN%3EE51%3C%2FSPAN%3E%2B%3CSPAN%3EF44%3AF50%3C%2FSPAN%3E%2C%3CSPAN%3EF41%3AF42%3C%2FSPAN%3E%2B%3CSPAN%3EE40%3C%2FSPAN%3E%2B%3CSPAN%3EF35%3AF39%3C%2FSPAN%3E%2B%3CSPAN%3EF25%3AF30%3C%2FSPAN%3E%2B%3CSPAN%3EF22%3AF23%3C%2FSPAN%3E%2B%3CSPAN%3EF19%3AF20%3C%2FSPAN%3E%2B%3CSPAN%3EF16%3AF17%3C%2FSPAN%3E%2B%3CSPAN%3EE15%3C%2FSPAN%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20can%20give%20me%20a%20heads%20up%20it%20would%20be%20really%20appreciated!%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EMirna%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-613901%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-613924%22%20slang%3D%22en-US%22%3ERe%3A%20Tried%20every%20which%20way%20to%20get%20rid%20of%20Value!%20-%20anyone%20willing%20to%20help%20me%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-613924%22%20slang%3D%22en-US%22%3ETry%20replacing%20all%20plus%20(%2B)%20signs%20with%20comma%20(%2C).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-613980%22%20slang%3D%22en-US%22%3ERe%3A%20Tried%20every%20which%20way%20to%20get%20rid%20of%20Value!%20-%20anyone%20willing%20to%20help%20me%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-613980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344598%22%20target%3D%22_blank%22%3E%40scratching_head_query%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20consider%20changing%20your%20model%20so%20you%20can%20use%20%3CSPAN%3Econtinuous%20ranges%20instead%20of%20individual%20cell%20references.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EEasier%20to%20maintain%2C%20easier%20to%20audit.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
scratching_head_query
Occasional Visitor

Hi Guys and Gals,

Getting frustrated so hoping someone more figures/excel orientated that I might be able to help. Keep on getting the Value! sign when I'm adding up a whole load of figures adding together (they're receipts). 

 

Please see my sum below which = Value!

What am I doing wrong? Have I put something extra in or added something?

I've gone up and down the list x6 times to check they are all in the correct places and no hidden extras. 

As you can see I'm adding 2 columns (card + cash columns)

I had thought blocking sections together e.g. E4:E20 would help to reduce the length of the sum. However is the problem because I'm mixing this with adding up? Or is that ok?

 

=SUM(E263+F266+F264+E258+E256+E23+F241+F240+E234+F221+F220+F213+F152+E217+E210+F209+F208+E201+E200+E194+E193+F12+F164:F174+E163+F162+F157+F156+F154+E129+F145+F124:F128+F130:F145+F114:F122+E113+F109:F110+F90:F94+F96:F104+E87+F81:F83+F61:F75+F56+F45+F44+F23+F162:F174+E150+E147+F110+F96:F104+F90:F94+E76+F61:F75+F58:F59+F53:F56+E51+F44:F50,F41:F42+E40+F35:F39+F25:F30+F22:F23+F19:F20+F16:F17+E15)

 

If anyone can give me a heads up it would be really appreciated!

Cheers,

Mirna

2 Replies
Try replacing all plus (+) signs with comma (,).

@scratching_head_query 

You should consider changing your model so you can use continuous ranges instead of individual cell references.

Easier to maintain, easier to audit.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies