View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cita Cita is offline
external usenet poster
 
Posts: 12
Default SUMPRODUCT problems...argh...

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