#N/A error in sumproduct
 

Try using error check or autofilter to check out you data in D2:D3000, with a
lot of data it can be easy to miss one error. If even one cell is a error it
can error out the sumproduct.
--
If this helps, please remember to click yes.


"Joe M." wrote:

Here is my formula:
=SUMPRODUCT((Data!$E$2:$E$3000=$A$1)*(Data!$C$2:$C $3000=$A3)*(Data!$D$2:$D$3000="N"))
If I remove the last segment *(Data!$D$2:$D$3000="N") then I get a result.
When it's included I get #N/A. In Data!D2:D3000 is the result of an =if that
results in Y or N. I also tried changing the =if to 1 or 0 with the same
result.
Can someone help?
Thanks!
Joe M.