Makor,
Couple of points.
First, what you are doing should work okay. What do you get, an error or a
wrong value?
Secondly, as you are just adding all the instances of 1, why not use
=SUMIF('mkr Calc Data'!F1:F1000,1)
or even
=COUNTIF('mkr Calc Data'!F1:F1000,1)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Makor" wrote in message
...
I am trying to use the SUMPRODUCT function to
http://j-walk.com/ss/excel/tips/tip48.htmworksheet - 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.