Excell

[Closed]
Report
-
 Ron -
Hello,
I have two sheet.. one is the master sheet containg the stock and the second sheet containing the sales invouice for a particular month. What i need is count the same number of article(item) sold in tat month and returned to a new correspondent cell which is in the master sheet.

suppose
0881..in the 1st sheet..

2nd sheet contains all the invoice for the month of dec08 day wise.

i need to find the tottal number of 0881 sold in that month and the value shud be returnd to the mastersheet.

thanks

2 replies

Posts
9
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 16, 2009

hi,
try this link to get help about calculating total in excel:
http://answers.google.com/answers/threadview/id/456608.html
hope it helps you.
Hi Sharaf,

For example If 0881 data is in A1 (first row and first column) Sheet1 and the invoice data is in sheet2

then type the formula =COUNTIF(Sheet2!A1:A13,Sheet1!A1) next to 0881 number in sheet1, which is masterfile, you should get the count there.

Regards,
Ron