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