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

$ anchors a reference cell to an absolute cell..

for example, if B1's formula is =A1 and you fill drag it down to B2.
B2's Formula becomes =A2.

Your particular formula tells excel that G3 is an absolute reference
and E14 is not. So if you fill drag this formula down. The cell below
it will have this formula: =SUM($G$3*E15)

I hope that helps, not very good at explaining =)

Do a search on references and read up on the difference between
relative and absolute references


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550431