SUMPRODUCT using data from multiple worksheets
 

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.