How can i keep adding a number to the number that shown in the cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-2149825%22%20slang%3D%22en-US%22%3EHow%20can%20i%20keep%20adding%20a%20number%20to%20the%20number%20that%20shown%20in%20the%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2149825%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHey%20everyone%2C%3CBR%20%2F%3Eim%20new%20in%20EXCEL%2C%20trying%20to%20build%20a%20stock%20control%20for%20my%20business.%3CBR%20%2F%3Eim%20trying%20to%20add%20a%20inventory%20for%20my%20excisting%20inventory%20and%20i%20dont%20know%20how%20to%20do%20it.%3CBR%20%2F%3Elet%20me%20ask%20it%20more%20simply%2C%20lets%20say%20i%20have%20a%20number%2C%20and%20a%20number%20to%20add.%3C%2FP%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22manmanman_5-1613755627788.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256069i525F2282F8AE83EC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22manmanman_5-1613755627788.png%22%20alt%3D%22manmanman_5-1613755627788.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Ei%20want%20to%20add%20the%206%20to%20the%2020%20and%20thats%20easy%3A%3C%2FP%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20c1cmiB1jfdq4sxidlPDAx%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CP%3E%3D20%2BF2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Ebut%20now%20i%20have%20a%20new%20number%2C%20and%20i%20want%20to%20add%20a%20number%20to%20it%20(to%20the%20new%20number).%20(number%3D26%20%2C%20add%3D2)%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Eand%20here%20is%20my%20problem-%20when%20im%20adding%20the%20%222%22%20its%20adding%20it%20to%20the%20%2220%22%20i%20put%20before.%3C%2FP%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22manmanman_6-1613755691758.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256070i133B21459096159B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22manmanman_6-1613755691758.png%22%20alt%3D%22manmanman_6-1613755691758.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Ei%20want%20to%20add%20the%20number%20to%20the%20number%20that%20shown%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ecells%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EAnyone%20have%20an%20idea%20for%20how%20can%20i%20fix%20it%20or%20maybe%20alternative%20way%3F%3CBR%20%2F%3Ehope%20i%20was%20clear!%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2149825%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
Occasional Visitor

Hey everyone,
im new in EXCEL, trying to build a stock control for my business.
im trying to add a inventory for my excisting inventory and i dont know how to do it.
let me ask it more simply, lets say i have a number, and a number to add.

 
manmanman_5-1613755627788.png

 

 
 

 

i want to add the 6 to the 20 and thats easy:

=20+F2

 

but now i have a new number, and i want to add a number to it (to the new number). (number=26 , add=2)

and here is my problem- when im adding the "2" its adding it to the "20" i put before.

 
manmanman_6-1613755691758.png

 

 

i want to add the number to the number that shown in the cells.

Anyone have an idea for how can i fix it or maybe alternative way?
hope i was clear!

Thanks in advance!

1 Reply

@manmanman 

 

Two things cannot occupy the same physical space. F2 cannot hold the values 2 and 6 at the same time.

 

You could put the numbers you want to add in their own cells below F2 and sum them using a formula like (note the sum function ignores text):

=SUM(20,F:F)

 

JMB17_1-1613760517089.png

 

Otherwise, if you want to do it the way you are trying, it would require vba.