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

--
Don Guillett
SalesAid Software

"cuteguy" wrote in message
...
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,
Shahid