Why do you "need" the total to reside in B1?

This method is very prone to errors which leave no "paper trail" for future
auditing.

You're always better off using a third cell to Sum 2 others.

See this google search result for more info, including code.

http://snipurl.com/1dmfi


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 09:55:16 -0700, Duffy
wrote:

need to add cell A1 to cell B1 and have the total reside in B1