all we have to do is highlight that cell, grab the corner, click and drag and you drag that all the way down and excel is automatically updated that equation and filled it into each row below for you with the correct references.