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).
|