Thanks, Kevin and Steve

Thats what I need but my problem is like you mentioned kevin in E4 it
gives the correct whole total but i need to keep a running total for
each cell so in other words one cell will say its minus 1 for that or
whatever and the next might be plus 2 ok under those in another cell
can it give me the running total of the plus 2 minus 2 or whatever the
actual numbers are ?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=505016