formula result blank
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 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,"--"),"-"))) |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com