excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1264746%22%20slang%3D%22en-US%22%3Eexcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264746%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20autosum%20in%20one%20cell.%20For%20instance%2C%20I%20have%20a%20category%20for%20gas%20receipts.%20I%20have%20%2410%20in%20that%20cell.%20I%20want%20to%20add%20a%20%245%20receipt.%20When%20I%20enter%205%20in%20that%20cell%20I%20want%20it%20to%20automatically%20add%20it%20to%20the%2010%20already%20in%20that%20cell%2C%20and%20keep%20going%20everytime%20I%20add%20a%20new%20receipt%20all%20year.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1264746%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-1264879%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264879%22%20slang%3D%22en-US%22%3EIf%20I%20understand%20your%20question%20clearly%2C%20assuming%20you%20have%20%3CBR%20%2F%3E10%20in%20A1%3CBR%20%2F%3E15%20in%20A2%3CBR%20%2F%3E13%20in%20A3%20%3CBR%20%2F%3E30%20in%20A4%3CBR%20%2F%3EAnd%20you%20want%20to%20add%205%20to%20each%20of%20these%20values%20in%20cells%20A1%20to%20A4%3F%20If%20that's%20what%20you're%20trying%20to%20achieve.%20All%20you%20need%20to%20do%20is%20use%20Paste%20Special%3CBR%20%2F%3EKindly%20follow%20the%20steps%20below%3CBR%20%2F%3E1.%20Type%20in%205%20in%20any%20empty%20cell%20and%20use%20CTRL%20%2B%20C%20to%20copy%3CBR%20%2F%3E2.%20Select%20all%20the%20values%20from%20A1%3AA4%3CBR%20%2F%3E3.%20Execute%20ALT%20%2B%20HVSD%20(this%20will%20select%20Add%20in%20the%20Paste%20Special%20dialogue%20box)%3CBR%20%2F%3E4.%20Click%20OK.%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20the%20steps%20will%20have%205%20to%20each%20of%20the%20value%20in%20that%20range%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264900%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264900%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BNo%20this%20is%20what%20I%20have%3C%2FP%3E%3CP%3E10%20in%20A2%2C%20I%20want%20to%20add%205%20to%20A2%2C%20then%20just%20keep%20adding%20to%20A2%20all%20year%20long.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264923%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F601049%22%20target%3D%22_blank%22%3E%40loriam1225%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20VBA%20programming%2C%20but%20I'd%20reconsider%20data%20model.%20Assume%20you%20have%20misprints%2C%20other%20data%20correction%20-%20that%20will%20be%20not%20easy%20task%20if%20entire%20history%20of%20changes%20is%20within%20log%20for%20A2.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264817%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F601049%22%20target%3D%22_blank%22%3E%40loriam1225%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20the%20solution%20is%20demonstrated%20in%20the%20attached%20workbook%20by%20using%20SUMIF.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264941%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264941%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20upload%20a%20sample%20file%20or%20the%20main%20file%20for%20between%20understanding%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to autosum in one cell. For instance, I have a category for gas receipts. I have $10 in that cell. I want to add a $5 receipt. When I enter 5 in that cell I want it to automatically add it to the 10 already in that cell, and keep going everytime I add a new receipt all year. Is this possible?

5 Replies
Highlighted

@loriam1225 

Perhaps the solution is demonstrated in the attached workbook by using SUMIF.

Highlighted
If I understand your question clearly, assuming you have
10 in A1
15 in A2
13 in A3
30 in A4
And you want to add 5 to each of these values in cells A1 to A4? If that's what you're trying to achieve. All you need to do is use Paste Special
Kindly follow the steps below
1. Type in 5 in any empty cell and use CTRL + C to copy
2. Select all the values from A1:A4
3. Execute ALT + HVSD (this will select Add in the Paste Special dialogue box)
4. Click OK.

All the steps will have 5 to each of the value in that range
Highlighted

@Abiola1 No this is what I have

10 in A2, I want to add 5 to A2, then just keep adding to A2 all year long.

 

Highlighted

@loriam1225 

That's with VBA programming, but I'd reconsider data model. Assume you have misprints, other data correction - that will be not easy task if entire history of changes is within log for A2.

Highlighted
Hello,

You can upload a sample file or the main file for between understanding