View Single Post
  #4   Report Post  
Pierre Leclerc
 
Posts: n/a
Default

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