Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 06-10-2016, 03:53 PM   #52
FromTheMorning
 
FromTheMorning's Avatar
 
Join Date: Dec 2011
Posts: 12,752

Shows Seen: 29

DMB Hub Stubs: 13

My Tour Central Stats

Re: Excel Help

Simple way would be to put =SUM(B2+C2) in cell D2 and then put your cursor in the bottom corner of the cell til you see a cross type thing. Then just drag that all the way down to whatever row the dates stop. That way every time you enter an amount in column B or C, it will automatically populate Column D. Given that it's excel, there are probably multiple ways to do it, but I'd say that's the easiest.

edit: well I guess I'm not needed anymore
FromTheMorning is offline   Reply With Quote