First thing I would do would be to *equalize* all the range references!

Your last 2 don't end at row 700 like the first 5 do.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Scott@CW" wrote in message
...
I cant figure out why I am getting the #NA error with the below formula.
There is data to match the critera in the formula range.

=SUMPRODUCT(($E$22:$E$700=$K$1)*($F$22:$F$700=$K$2 )*($G$22:$G$700=$K$3)*($H$22:$H$700=$K$4)*($I$22:$ I$700=$K$5)*($J$22:$J$695=$K$6)*(K$22:K$695=$J12))

K1 through K6 are all referencing a Data validation list on another page.

Please help.