Glad to help. Thanks for the feedback.

Fred.

"Joe M." wrote in message
...
Yes my Data!D column contained some invalid data with #N/A. Thanks for
your
help!

Joe M.

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