what a guy! that works just like i wanted
thanks Thomas
Jay



On Wed, 8 Oct 2008 13:02:02 -0700, Thomas [PBD]
wrote:

Jay,

Ah-ha. I see. Well, try this instead:
E1: =IF(D1="","",D1)
E2: =IF((SUM($D$1:D2)-SUM($D$1:D1))=0,"",SUM($D$1:D2))

You can pull this formula down as far as you need it. I assumed that E1 was
not a header, if it is you can simply use the second formula from the first
record through the last.