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

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

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

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

If you want a list, make a list
dog 100
cat 10
=vlookup(b2,listrange,2,0)-sumif($b$2:$b$200,b2,$d$2:$d$200)


--
Don Guillett
SalesAid Software

"Roelamp" wrote in message
...
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