Sumproduct returning N/A

[miami2k]

Dear All,
I have this formula that works based on two sheets:

=SUMPRODUCT((Fatt!$G$2:$G$7338=Contr!G16)*(Fatt!$E$2:$E$7338=Contr!E16))

Columns E are dates Columns G are an amount.

If I change the formula using another field of the 2 tables the result is N/A:

=SUMPRODUCT((Fatt!$U$2:$U$7338=Contr!B17)*(Fatt!$E$2:$E$7338=Contr!E17))

In this case column U and B are both numbers. I've tried to change the format and other things but for some reason on this fields it's not returning the result.

Thank you!


miami2k

 

[jasonb75]

Check the range, Fatt!$U$2:$U$7338 for errors. There is no reason for the formula to return N/A other than existing errors in that range.

The other option is to use COUNTIFS (which will ignore the #N/A error as an alternative to SUMPRODUCT.

 

[miami2k]

There were N/A in the source column, thank you very much!