Using:
=SUMPRODUCT(Detail!Region="james")*(detail!Contrac t="n/g")*(detail!Amount)
returns #NUM! Could this be because some cells in Amount range are blank? I
appreciate the help