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
 
Shitu,

Assuming your items start in column A and go through column F, in the order
given.

On another sheet, list your Item names in column A starting in cell A2, and
in column B, use the formula:
=SUMIF(Sheet1!D:D,A2,Sheet1!E:E)-SUMIF(Sheet2!D:D,A2,Sheet2!E:E)
Copy down to match your Item list.

HTH,
Bernie
MS Excel MVP
 
Hans

Make an extra sheet and put in column A all possible items.

In Column B you use the SUMIF function that refers to
column A and sheet 1. (See help how to use SUMIF).

In Column C you use the SUMIF function that refers to
column A and sheet 2.

In Column D you calculate the difference between column B
and C.

Regards,
Hans
 
Back
Top