which function use?

  • Thread starter Thread starter shitu
  • Start date Start date
S

shitu

i have 2(two) sheet where i have in sheet1 purchase
infomation & in sheet2 sales infomation. i what to
maintain stock of goods.

in sheet1 i have heading like.
date,bill no.,name of co.,Item,qty,rate.

in sheet2 i have heading like.
date,bill no.,name of co.,Item,qty,rate.

if i purchase goods (e.g.pan ) qty 1000 & sale to
different person 200, 300, 100 how i maintain stock of
that... any help?

shital shah
..
 
Just add up the purchases and the sales quantities for that item using
Sumif. then subtract the sales from the purchases and you have the onhand
quantity.
 
Back
Top