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.

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." wrote in message
...
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.

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.

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.