Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel function
I have set up a worksheet I have my 150 items in a list in say colum A I
would like to keep a running inventory for example: date item cost sold avaliable 1/1/5 Dog 149.00 1 6 1/2/5 Cat 100.00 1 3 1/3/5 Dog 149.00 1 5 thanks for your help Rosie |
#2
|
|||
|
|||
You don't say what you start with but this might work
=100-sumif($b$2:$b$200,b2,$d$2:$d$200) -- Don Guillett SalesAid Software "Roelamp" wrote in message ... I have set up a worksheet I have my 150 items in a list in say colum A I would like to keep a running inventory for example: date item cost sold avaliable 1/1/5 Dog 149.00 1 6 1/2/5 Cat 100.00 1 3 1/3/5 Dog 149.00 1 5 thanks for your help Rosie |
#3
|
|||
|
|||
Don,
Thank you but I'm affraid it's not working to be more clear say I started with 50 of 0ne item but only 10 of another. Should I be making a list or doing something else? Sorry I hope you this better explains it. Thanks "Don Guillett" wrote: You don't say what you start with but this might work =100-sumif($b$2:$b$200,b2,$d$2:$d$200) -- Don Guillett SalesAid Software "Roelamp" wrote in message ... I have set up a worksheet I have my 150 items in a list in say colum A I would like to keep a running inventory for example: date item cost sold avaliable 1/1/5 Dog 149.00 1 6 1/2/5 Cat 100.00 1 3 1/3/5 Dog 149.00 1 5 thanks for your help Rosie |
#4
|
|||
|
|||
you need more columns!
item cost datestocked stock sold stock on hand dog 149 1/1/5 7 1 6 cat 100 1/1/5 4 1 3 new stock would be typed into column '"stock",losses could be adusted in "stock" . Do you intend to update the list manually or will it be sold from this database via lists etc hoppe this helps Paul "Roelamp" wrote: Don, Thank you but I'm affraid it's not working to be more clear say I started with 50 of 0ne item but only 10 of another. Should I be making a list or doing something else? Sorry I hope you this better explains it. Thanks "Don Guillett" wrote: You don't say what you start with but this might work =100-sumif($b$2:$b$200,b2,$d$2:$d$200) -- Don Guillett SalesAid Software "Roelamp" wrote in message ... I have set up a worksheet I have my 150 items in a list in say colum A I would like to keep a running inventory for example: date item cost sold avaliable 1/1/5 Dog 149.00 1 6 1/2/5 Cat 100.00 1 3 1/3/5 Dog 149.00 1 5 thanks for your help Rosie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Is there a Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
Return value with using Excel function | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |