Take a look here (change + to *):

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
Tim wrote:

I'm having some difficulity in mulitplying two cells together, while entering
a number in the same cell. I guess it is called circular reference... They
say it is possible as long as you tell the cell how many times it will
change. How do I do this. Example... B2*B4. B2 = $55.00 B2= 4 I Want B2
to calculate the new total.