The ranges need to be of equal size, the last 2 end at row 695 and not 700
like the other


--
Regards,

Peo Sjoblom


"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.