Paste this code into a standard module:

Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function

Then with your numbers in A1:A5
and your =sum(A1:A5) in A6
Enter into B1 and Copy Down to B6

=if(HasFormula(A1),A1,"")

That you get you what you want..





"SteveG" wrote in
message ...

Not sure if there is more info that would no enable you to do this but
if your total is in A10, in the cell in column B that you want to carry
the sum to

=A10

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=521230