View Single Post
 
Old 10-01-2015, 04:15 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Go to the Formulas ribbon, in Formula Auditing section select Show Formulas so you can see the progression of all the formulas.

In column B all those D3 should be $D$3 and in column K the K3 should be $K$3 for the formulas to maintain the addition of the constant when being dragged.
Reply With Quote