Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula returns #N/A | Excel Discussion (Misc queries) | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
Help with Formula, returns #NAME! | New Users to Excel | |||
Formula returns 0 | Excel Worksheet Functions |