Thanks for the efforts I copied the formula exactly and I'm still getting an
N/A in my formula cell. I've looked at all 3 columns used in the formula and
there are no #N/A errors

I'm not sure what else to check.



"Bob Phillips" wrote:

No I do not mean blanks in column K, I mean #N/A values, blanks are ignored
when summing.

You will need SUMPRODUCT if you want to test two conditions, like so

=SUMPRODUCT(--('Working Copy'!A3:A1038=WC_WPH!A56),--('Working
Copy'!J3:J1038=0),'Working Copy'!K3:K1038)


--
HTH

Bob Phillips