try this...

=SUMPRODUCT(--(DropCode_Log!$B$10:$B$400=Totals!$A$17),
--(DropCode_Log!$C$10:$C$400=Totals!$A19),
--(DropCode_Log!$D$10:$D$400=Totals!B$18),
--(DropCode_Log!$G$10:$G$400="SIK"))

--
HTH...

Jim Thomlinson


"Cita" wrote:

Hello, once again, I have to read 4 columns of info and count the records.
Here's the formula:

=SUMPRODUCT(--(DropCode_Log!$B$10:$B$400=Totals!$A$17)*(DropCode _Log!$C$10:$C$400=Totals!$A19)*(DropCode_Log!$D$10 :$D$400=Totals!B$18)--(DropCode_Log!$G$10:$G$400="SIK"))

Where Column B are dates, Column C are categories, Column D is a 2nd
category, and Column G are codes...

What am I doing wrong?

Thanks in advance...