super_almoner Posted July 13, 2012 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!
Batman Posted July 13, 2012 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.
super_almoner Posted July 13, 2012 Author Posted July 13, 2012 Do I write in =(column 1)-(column 2)? Because if yes, I think I'm missing something here...
Noog Posted July 24, 2012 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.
super_almoner Posted July 25, 2012 Author 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!
Noog Posted July 25, 2012 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.
Recommended Posts