Cell returns blank result...
 

I have a formula that I used on a previous spreadsheet. I have changed it to
reflect the current year. The formula yields a result when I click on the
formula palette, however the cell display is blank. Any help would be
greatly appreciated. I have checked all formatting, conditional formatting,
etc. All the other cells that were updated display the results, except for
the following. It appears that the formula interprets the iserror as true
when it is false...

Below is an example of the formula:

=IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-")))

Cell returns blank result...
 

Are you entering the formula as an array?

Try removing the error trap and see what error is being generated.

I can't test it with that path!

Biff

"Leonard" wrote in message
...
I have a formula that I used on a previous spreadsheet. I have changed it
to
reflect the current year. The formula yields a result when I click on the
formula palette, however the cell display is blank. Any help would be
greatly appreciated. I have checked all formatting, conditional
formatting,
etc. All the other cells that were updated display the results, except
for
the following. It appears that the formula interprets the iserror as true
when it is false...

Below is an example of the formula:

=IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-")))

Cell returns blank result...
 

Thanks for replying... I finally found out... All I needed was to commit the
formula with CTRL shift enter...

"T. Valko" wrote:

Are you entering the formula as an array?

Try removing the error trap and see what error is being generated.

I can't test it with that path!

Biff

"Leonard" wrote in message
...
I have a formula that I used on a previous spreadsheet. I have changed it
to
reflect the current year. The formula yields a result when I click on the
formula palette, however the cell display is blank. Any help would be
greatly appreciated. I have checked all formatting, conditional
formatting,
etc. All the other cells that were updated display the results, except
for
the following. It appears that the formula interprets the iserror as true
when it is false...

Below is an example of the formula:

=IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-")))