Formular

Hi Monika, Thank you for your question, I hope you enjoyed the Excel Intro Course, in answer to your question, the dollar sign ($) when placed in front of row and/or column indicator will indicate to Excel that the cell reference is to be considered totally or partially Absolute. In a normal formula (without $ signs) a pattern is created and remembered by Excel, so if you copy using the Fill handle (drag the little square in the corner of the selected cell) Excel will reference cells in the new copied locations by the pattern originally created; for example if a formula is =A1*A10 and the result is in A11, using the Fill handle to copy the formula to B11 will create a formula B1*B10, this is known as Relative Referencing. However if you apply the $ signs to your formula; for example, =$A$1*A10, again with the result in A11, using the fill handle to copy the formula to B11 will create the formula =$A$1*B10, the $ signs have fixed the focus on A1, this is known as Absolute Referencing. I hope that has helped, if it has please click the Resolved link, best regards Pete.