Hi
In the range that you are summing, there is text or spaces. It is the
most common error messge when using SUMPRODUCT.
For a complete tutorial on SUMPRODUCT and other functions and formula
see the site below
http://www.excel-vba.com
Pierre Leclerc
http://www.excel-vba.com