Thanks that worked great . I am sorry if I had to get your attention. I do really appreciates all the help. Its hard to trouble shoot these problems. Excel is not very helpfull on guiding where the issue is.

thanks


On Tuesday, March 26, 2013 2:16:41 PM UTC-5, Claus Busch wrote:
Hi,



Am Tue, 26 Mar 2013 12:08:46 -0700 (PDT) schrieb Please work this

time...:



=SUMPRODUCT((Sheet3!AP8:AP107<=500)+(Sheet3!AQ8:AQ 107<=500)+(Sheet3!AR8:AR107<=500))*(Sheet3!C8:C107 <"*")*(Sheet3!AH8:AH107<"*")*(Sheet3!AL8:AL107< "*")



in the formula above I miss a bracket:

=SUMPRODUCT(((Sheet3!AP8:AP107<=500)+(Sheet3!AQ8:A Q107<=500)+(Sheet3!AR8:AR107<=500))*(Sheet3!C8:C10 7="r")*(Sheet3!AH8:AH107="r")*(Sheet3!AL8:AL107="r "))

In each row must the conditions be true.

If this formula gives not the expected result you must change your

conditions.





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2