Previous Topic Next Topic

Excell

Closed
sharaf - Feb 4, 2009 at 02:37 AM
 Ron - Feb 4, 2009 at 04:38 AM
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

Answer 1 / 2
daniele258
Posts
9
Registration date
Sunday January 4, 2009
Status
Member
Last seen
June 16, 2009
Feb 4, 2009 at 04:32 AM
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.
0
Answer 2 / 2
Ron
Feb 4, 2009 at 04:38 AM
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
0