#N/A error in sumproduct

[Joe M.]

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!D23000 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.

 

[Fred Smith]

Somewhere in your D column, you have a cell with #N/A in it. Try turning on
Autofilter. It will show you the different contents you have in the cells in
Column D, and point you to the ones which aren't Y or N

Regards
Fred.

 

[Joe M.]

Yes my Data!D column contained some invalid data with #N/A. Thanks for your
help!

Joe M.

 

[Fred Smith]

Glad to help. Thanks for the feedback.

Fred.

Yes my Data!D column contained some invalid data with #N/A. Thanks for
your
help!

Joe M.