Assuming Date, Task Name, and Remarks are entered in columns A, B, and C of
sheet1 respectively - on sheet2 enter the following:
A B C
1 9/15/05 Incoming
2 9/15/05 Outgoing
In cell C1 enter
=SUMPRODUCT(--(Sheet1!$A$1:$A$65535=A1),--(Sheet1!$B$1:B65535=B1),--(Sheet1!$C$1:C65535="OK"))
and copy down to cell C2, C3, etc.
This will count the number of items in your table that match the given date,
incoming/outgoing, and are OK.
Is this what you are wanting?
"dj_george" wrote:
Hi can any one help me on this
In sheet1 we have the data
Date Task name Remarks
9/15/2005 Incoming OK
9/15/2005 Outgoing OK
9/15/2005 Incoming Not OK
9/16/2005 Outgoing OK
9/16/2005 Outgoing OK
9/16/2005 Incoming OK
In sheet2 i need data for that particular date of that task only if it is OK
Eg: - on 15 - Sep it should 1 only one record in total if it is OK and task
is Incomig
On 16/sep it should be 2 outging and 1 incoming
Pls help me.
|