SOLVED

simple stuff i try to do

%3CLINGO-SUB%20id%3D%22lingo-sub-1887624%22%20slang%3D%22en-US%22%3Esimple%20stuff%20i%20try%20to%20do%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887624%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20have%20not%20used%20excel%20in%20a%20very%20long%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20some%20simple%20adding%20without%20having%20to%20input%20the%20whole%20selection%20but%20by%20selecting%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20have%20multiple%20cells%20and%20I%20want%20to%20add%20them%20up%20to%20another%20in%201%20cell%20in%201%20go.%20How%20can%20I%20fast%20select%20these%20cells%20with%20having%20to%20put%20%2B%20in%20between%20every%20cell%20while%20manually%20to%20select%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20instead%20of%20%3DA1%2BA2%2BA3%2BA4%2BA5%2BA6%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20select%20A1%20with%20the%20mouse%20put%20a%20%2B%20and%20than%20select%20A2%20with%20the%20mouse%20and%20while%20holding%20the%20mouse%20select%20all%20the%20other%20cells%20that%20need%20to%20be%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20get%20what%20I%20do%20wrong%2C%20I%20always%20get%20a%20value%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20it%20looks%20like%20%3A%20%26nbsp%3B%26nbsp%3B%20%3DA1%2BA2%3AA11%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1887624%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-1887852%22%20slang%3D%22en-US%22%3ERe%3A%20simple%20stuff%20i%20try%20to%20do%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887852%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869178%22%20target%3D%22_blank%22%3E%40Sebastian1987%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20about%20%3DSUM(%3CSPAN%3EA1%3AA6)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20can%20click%20on%20the%20SUM%20button%20in%20the%20ribbon%20then%20select%20the%20range%20with%20your%20mouse%2C%20or%20simply%20type%20in%20the%20%3DSUM(A1%3AA6)%20formula.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887856%22%20slang%3D%22en-US%22%3ERe%3A%20simple%20stuff%20i%20try%20to%20do%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887856%22%20slang%3D%22en-US%22%3EIf%20you%20want%20to%20automate%20this%20you%20need%20a%20VBA%20Macro%2C%2C%20otherwise%20keyboard%20is%20the%20ultimate%20option.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

So I have not used excel in a very long time.

 

I'm trying to do some simple adding without having to input the whole selection but by selecting cells.

 

What I want to do :

 

If I have multiple cells and I want to add them up to another in 1 cell in 1 go. How can I fast select these cells with having to put + in between every cell while manually to select them.

 

So instead of =A1+A2+A3+A4+A5+A6

 

Just select A1 with the mouse put a + and than select A2 with the mouse and while holding the mouse select all the other cells that need to be added.

 

I don't get what I do wrong, I always get a value error

 

This is how it looks like :    =A1+A2:A11

 

 

 

 

 

 

2 Replies
Highlighted
Best Response confirmed by Sebastian1987 (Occasional Visitor)
Solution

Hi @Sebastian1987,

 

How about =SUM(A1:A6)

 

You can click on the SUM button in the ribbon then select the range with your mouse, or simply type in the =SUM(A1:A6) formula.

Highlighted
If you want to automate this you need a VBA Macro,, otherwise keyboard is the ultimate option.