I'm attempting to make a spreadsheet that always subtracts the previous day's total from today's total. i.e. (=SUM(C15-C14)). Is there a way to make this column always do that, versus entering the dx-dy formula in every row?
I'm attempting to make a spreadsheet that always subtracts the previous day's total from today's total. i.e. (=SUM(C15-C14)). Is there a way to make this column always do that, versus entering the dx-dy formula in every row?
You just need to enter the formula in one cell and then copy it down.
To copy it down, place the mouse cursor in the lower right corner of the cell. When the cursor changes to a + (plus), click and drag down.
Note : You can simplifyy your formula to =C15-C14
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
WOW. that really was stupid simple. I'm sorry and thankful for your assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks