Actual question
Forums › General Discussion › Actual question-
Trying to set up a spreadsheet on excel. Can't figure out how to make columns automatically add them selves. I want columns D+E to add together and put value in F. Also want F to update every line (like a year to date total). Any help?
-
Highlight D+E+F than look for the little E looking thing in the top right hand corner for auto sum.
-
One more thing, I also have to have words on row 1 for headings. Think that's what's messing me up.
-
Format the cells in row 1 for text. If you need more space for text use more rows by merging cells. Add borders and change fonts in the 'format cells' popup if you'd like. Start your summations on row 2 or whatever. For your year-to-date totals, put a cell at the bottom of column F that sums all of the cells in column F.
-
Select the cell you want to have a summation of values to be logged in. =sum(hold control and select the cells you want to add together)
-
Or just highlight the cell where to total goes - double click on fx. Choose sum and enter row numbers. There's a billion ways to use excel. Lots of tutorials to be googled too.
-
=sum(d##+e##) in the f column, then drag down
-
YOU wrote:
That's to add the two together, from there on if you want the old F added make the rest this way =sum(d2+e2+f1) I think - I usually just play with the formulas till it comes out right lol - to lock a cell in the addition make the cell ($d$2+e2+f1) and when u drag down it won't change d2 cell as it goes down=sum(d##+e##) in the f column, then drag down
-
YOU wrote:
Although I haven't double checked this - if I had excel in front of me I could do it real easilyYOU wrote:
That's to add the two together, from there on if you want the old F added make the rest this way =sum(d2+e2+f1) I think - I usually just play with the formulas till it comes out right lol - to lock a cell in the addition make the cell ($d$2+e2+f1) and when u drag down it won't change d2 cell as it goes down=sum(d##+e##) in the f column, then drag down
![[][]](https://turfwarsapp.com/img/app/ajax-forbutton.gif)
Purchase Respect Points NEW! · Support · Turf Map · Terms · Privacy
©2021 MeanFreePath LLC