how i maintain stock ?

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

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
 
=sumif(Sheet1!D:D,"Pan",Sheet1!E:E)-Sumif(Sheet2!D:D,"Pan",Sheet2!E:E)

You can change "Pan" to a cell reference that contains the item name.
 
=sumif(Sheet1!D:D,"Pan",Sheet1!E:E)-Sumif(Sheet2!D:D,"Pan",Sheet2!E:E)

You can change "Pan" to a cell reference that contains the item name.
 
Back
Top