View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default SUMPRODUCT problems...argh...

Well, you do have a comma missing before the second --, and also I
don't think you need the first --. Actually, you don't need the second
-- if you change it to *, so try this:

=SUMPRODUCT((DropCode_Log!$B$10:$B$400=Totals!$A$1 7)*(DropCode_Log!$C
$10:*$C$400=Totals!$A19)*(DropCode_Log!$D$10:$D$40 0=Totals!B
$18)*(DropCode_Log!*$G$10:$G$400="SIK"))

Hope this helps.

Pete

On Sep 23, 3:54*pm, 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$1 0:$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...