The dollar sign changes the cell reference from relative to absolute. When
copying formulas containing cells references if you do not include the "$ the
reference will change relative to where it is moved from. For example if you
had the following formula in cell A5: =Sum(A1:A4) and you copied this formula
to cell B5, the formula in B5 would read =Sum(B1:B4), it would have increased
by one column since you are pasting one column over. This also holds true to
rows. If you had included the "$" in the fomula, =Sum($A1,$A4) and copied it
over you would have noticed it would not have changed and the formula in B1
would show = Sum($A1:$A4).

"bldurgin" wrote:

I am unable to find in search of Help files or Reference online. Here's the
fomula:
=SUM($G$3*E14)