software

Hi
I am new in EXCEL. I am tired to lookup the function of the following :

I need to know a correct formulae to lookup my stock report. I created a
table that i am entering everyday sale in every cell in vertical order. when
i enter the sale in the cell it should be automatically deducted in TOTAL
STOCK. Is it possible?

Please guide me...

Regards,
Shahidmaybe something like it the total is in a1
=a1-sum(a2:a200)

--
Don Guillett
SalesAid Software

quot;cuteguyquot; gt; wrote in message
...
gt; Hi
gt; I am new in EXCEL. I am tired to lookup the function of the following :
gt;
gt; I need to know a correct formulae to lookup my stock report. I created a
gt; table that i am entering everyday sale in every cell in vertical order.
gt; when
gt; i enter the sale in the cell it should be automatically deducted in TOTAL
gt; STOCK. Is it possible?
gt;
gt; Please guide me...
gt;
gt; Regards,
gt; Shahid
gt;