super_almoner Posted July 13, 2012 Share Posted July 13, 2012 Okay, I'm working on a budget and I don't want to have to manually add amounts. Is there a way to make the following happen without imputing it every time: Column A is the account balance Column B is the expense Column C is the sum of these BUT. I want each row to add up separately, I don't want the column to add up... so I want C1 to show the sum of A1 and B1; C2 to show the sums of A2 and B2; C3 the sums of A3 and B3, etc. Does that make sense? Any help would be appreciated! Link to comment Share on other sites More sharing options...
Batman Posted July 13, 2012 Share Posted July 13, 2012 There is a pretty simple solution. Put the numbers in the two rows how you want them. Do the =(column 1)-(column 2) for the first two then grab those two boxes that have the total and drag them down (not move them) it will continue the trend all the way down. Link to comment Share on other sites More sharing options...
super_almoner Posted July 13, 2012 Author Share Posted July 13, 2012 Do I write in =(column 1)-(column 2)? Because if yes, I think I'm missing something here... Link to comment Share on other sites More sharing options...
Noog Posted July 24, 2012 Share Posted July 24, 2012 In C1, put =A1+B2 After that, use the fill handle to drag the formula down the C column. Here's a picture that should help you locate the fill handle. Link to comment Share on other sites More sharing options...
super_almoner Posted July 25, 2012 Author Share Posted July 25, 2012 Ohh! I got it now! Haha, I haven't really used Excel before, so this taught me a lot. Thanks so much! Link to comment Share on other sites More sharing options...
Noog Posted July 25, 2012 Share Posted July 25, 2012 No problem. The fill handle will copy any formula to change with columns/rows. Also, it can do series. For example, if you select two cells containing "January" and "February" and dragged the fill handle, it would fill the next cells with the following months. This topic has been edited by a member of staff (Neomysterion). The original topic had been answered. Please check your user inbox to see if you have been contacted regarding this topic. Per the reason above, this topic has been LOCKED. Please contact Neomysterion if you have any questions regarding this action. Link to comment Share on other sites More sharing options...
Recommended Posts