Hi
the formula looks o.k.. What kind of error do you get?.

Note: you can shorten this formula to:
=SUMPRODUCT(--('mkr Calc Data'!F1:F1000=1))

or
=COUNTIF('mkr Calc Data'!F1:F1000,1)


-----Original Message-----
I am trying to use the SUMPRODUCT function to analyze
data in a second worksheet called "mkr Calc Data. However,
it seems that I cannot use references to a seperate
worksheet - I even tried using named ranges.
Here is the calc I am using.
=SUMPRODUCT(('mkr Calc Data'!F1:F1000=1)*('mkr Calc Data'!
F1:F1000))

Help.
.