Home

Excel Questions

%3CLINGO-SUB%20id%3D%22lingo-sub-344385%22%20slang%3D%22en-US%22%3EExcel%20Questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344385%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3ESo%20I'm%20an%20I.T.%20guy%20that's%20new%20to%20Excel.%20I%20know%20just%20enough%20about%20it%20to%20get%20myself%20in%20trouble.%20I%20have%20a%20simple%20Excel%20spread%20sheet%20that%20I%20have%20but%20together%2C%20basically%20long%20story%20short%2C%20I%20need%20to%20be%20able%20to%20do%20this%3A%20I%20want%20to%20take%20one%20column%20and%20take%20the%20sum%20of%20a%20cell%20below%20another%20cell%20and%20display%20the%20difference%20in%20that%20cell%2C%20if%20that%20makes%20sense.%20I%20need%20to%20carry%20that%20formula%20all%20the%20way%20down%20the%20work%20sheet%2C%20very%20simple%20formula%2C%20just%20didn't%20know%20how%20to%20say%20%22continue%20this%20all%20the%20way%20down%20this%20column.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3Eriders36%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-344385%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESum%20Function%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-344443%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344443%22%20slang%3D%22en-US%22%3EHover%20over%20the%20cell%20you%20want%20to%20%22carry%20down%22%20until%20your%20cursor%20becomes%20a%20%2B%20and%20click%20and%20drag%20down.%3CBR%20%2F%3EGood%20luck!%3C%2FLINGO-BODY%3E
Highlighted
riders36
Occasional Visitor

Hey guys,

So I'm an I.T. guy that's new to Excel. I know just enough about it to get myself in trouble. I have a simple Excel spread sheet that I have but together, basically long story short, I need to be able to do this: I want to take one column and take the sum of a cell below another cell and display the difference in that cell, if that makes sense. I need to carry that formula all the way down the work sheet, very simple formula, just didn't know how to say "continue this all the way down this column."

 

Thanks,

riders36  

1 Reply
Highlighted
Hover over the cell you want to "carry down" until your cursor becomes a + and click and drag down.
Good luck!
Related Conversations
Deleted excel files
Rick0302 in Excel on
1 Replies
Printing underlines
Gary7777 in Excel on
2 Replies
Date Format in Pivot Tables
KimbersHulme in Excel on
1 Replies
Question One: Protect Format & Two: Formula
Richard_James in Excel on
0 Replies
Excel question.
skbp1970 in Excel on
6 Replies