You are missing the "--" before the 1st condition and the "," before the
last

"Rob" wrote in message
...
I should be able to do this by now but I keep getting an #NA error. I am
trying to use this sumproduct formula
=SUMPRODUCT(($I$7:$I$2585=921),--($L$7:$L$2585="Fb")--(AS7:AS2585)) where
I
am looking up store #"921" and Attribute "fb and sum where these two
criteria
meet. The column I want to sum is AS7:As285. What am I doing wrong.