Thanks, You were of great help to me.

One last clarification. I feel that due to these functions the file size
seems to be huge, bcoz i need to calculate data for a whole month.(records
crossing 15000). Any suggestions.

"JMB" wrote:

try this formula

=SUMPRODUCT(--(Sheet1!$A$1:$A$65535=$A2),--(Sheet1!$B$1:B$65535=$B2),(Sheet1!$C$1:C$65535="Re viewed")+(Sheet1!$C$1:C$65535="OK"))

"dj_george" wrote:

Thanks, It works. Just one clarification. Can't we calculate Reviewed and OK
records in the same column.

"JMB" wrote:

I would include headers on Sheet2.

A B C D
1 DATE TASK REVIEWED OK
2 9/15/05 Incoming
3 9/15/05 Outgoing


In cell C2 enter


=SUMPRODUCT(--(Sheet1!$A$1:$A$65535=$A2),--(Sheet1!$B$1:B$65535=$B2),--(Sheet1!$C$1:C$65535=C$1))

then copy across to cell D2, and down as far as you need. I also had to
make a correction to a previous mistake - I had omitted the "$" in front of
"65535" in my previous post - so be sure to include the "$" in your formula
(otherwise you will get an error when you start copying).