Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |