Formula Returns #N/A
 

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

Formula Returns #N/A
 

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(Data Region))="Latin America")*
(DataAmount))



--
Regards,
Tom Ogilvy


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