excel function

R

Roelamp

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
 
D

Don Guillett

You don't say what you start with but this might work
=100-sumif($b$2:$b$200,b2,$d$2:$d$200)
 
R

Roelamp

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
 
P

paul

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
 
D

Don Guillett

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)
 
Top