Each array argument of the sumproduct function must have the same number of
elements. But you've got some that reference rows 22 through 700 and others
that reference 22 through 695. Try
=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$700=$K$6),(K$22:K$700=$J12))


"Scott@CW" wrote:

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.