Home

ADDING IN THE SAME CELL

%3CLINGO-SUB%20id%3D%22lingo-sub-822866%22%20slang%3D%22en-US%22%3EADDING%20IN%20THE%20SAME%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822866%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20where%20I%20can%20add%20up%20at%20the%20end%2C%20but%20I%20also%20want%20to%20be%20able%20to%20add%20say%2042%2B98%2B67%20in%20the%20same%20cell.%20How%20do%20I%20do%20this%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-822866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823040%22%20slang%3D%22en-US%22%3ERE%3A%20ADDING%20IN%20THE%20SAME%20CELL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823040%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20not%20appear%20to%20achieve%20that%20much%20but%20if%20you%20turn%20the%20text%20into%20a%20formula%20by%20inserting%20an%20equals%20sign%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D42%2B98%2B67%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ethe%20formula%20will%20evaluate%20based%20on%20the%20embedded%20constants.%20Other%20forms%20include%20summing%20an%20array%20constant%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(%20%7B42%2C98%2C67%7D%20)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eor%20SUM%20with%20three%20individual%20parameters.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(42%2C%2098%2C%2067)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
RIVERSIDE
Occasional Visitor

I have a list where I can add up at the end, but I also want to be able to add say 42+98+67 in the same cell. How do I do this??

1 Reply

I would not appear to achieve that much but if you turn the text into a formula by inserting an equals sign

=42+98+67

the formula will evaluate based on the embedded constants. Other forms include summing an array constant

= SUM( {42,98,67} )

or SUM with three individual parameters.

= SUM(42, 98, 67)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies