Formula Returns #N/A

[Shashi Bhosale]

I have Following Formula .

=SUMPRODUCT((TRIM(DataRegion)="Latin America")*
(DataAmount))

( DataRegion is a calculated fields and the formaula is
(=VLOOKUP(C117,Regions,2)) )

There is a data with "Latin America".

The SUMPRODUCT formula return me #N/A. What could be the problem?

Thanks in advance,

Shashi

 

[Tom Ogilvy]

generally it will do this if any part of your formula returns #N/A - for
example if it is in a cell in DataAmount or in the results of a cell in
DataRegion.

perhaps try

=SUMPRODUCT(if(iserror(DataRegion),False,TRIM(DataRegion))="Latin America")*
(DataAmount))