Thanks it works, just one more thing if the remark also says Reviewed and i
need the data for both "OK" and "Reviewed" or that particular date and task.

Please advise.

"JMB" wrote:

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.