Domenic wrote:
In article ,
Aladin Akyurek wrote:


An #N/A cannot go thru the ISNUMBER tests that figure in the formula.

Here is an example intermediate state of evaluation:

=SUMPRODUCT(--ISNUMBER({#N/A;2;6;#N/A;3;#N/A;#N/A}),--ISNUMBER(1/({#N/A;"No";"
Yes";#N/A;"No";#N/A;"No"}="Yes")),{5;6;4;7;8;9;6})


In theory, the above formula should return 4. The problem is that it
returns 0 and I get the following error message...

"Microsoft Excel cannot calculate the formula..."

I understand that the next stages of the evaluation would be as
follows...

=SUMPRODUCT({0;1;1;0;1;0},{0;0;1;0;0;0},{5;6;4;7;8 ;9})

=SUMPRODUCT({0;0;4;0;0;0})

So why am I getting an error?

No idea. I myself get 4. Want me to send you the workbook?