Problems with a SumProduct Calculation

[Mark]

I have a sheet with data pulled back from a server which is below:-

04/03/2004 6998 12 1800 0 0 0
04/03/2004 6998 12 574 0 0 0
04/03/2004 6998 12 1800 0 0 0
04/03/2004 6990 20 1800 0 0 0
04/03/2004 6990 20 1800 0 0 0
04/03/2004 6990 20 1800 0 0 0
04/03/2004 6990 20 1800 0 0 0
04/03/2004 6990 20 843 0 0 0

I use this sumproduct to do the calculation of column C, this works
when the formula is on the same worksheet as the data but if I put the
formula onto sheet2 it comes back with Zeros...

I have tried copying a section of the data and pasting it onto the
second sheet and it works but when I tri to referance the a diffrent
sheet to the formula is comes back with zeros again!!!

=SUMPRODUCT(((B13:B20="6998")*(C13:C20=12))*(D1320))

any ideas??

Cheers
Mark

 

[Frank Kabel]

Hi
you have to include the sheet reference. e.g.
=SUMPRODUCT((('sheet1'!B13:B20="6998")*('sheet1'!C13:C20=12))*('sheet1'
!D1320))

 

[sh0t2bts]

Duh!!


I can't believe I made such a simple error....


Thank You

Mark )