Indirect Address Column Formula help needed

[trankim]

BRILLIANT....it works! thanks so MUCH!

[trankim]

I tried to be creative and see if it worked using the same formula to calculate week over week. However, the above formula isn't working for me too well. If the reported week is not calculated, it technically shows a zero, which you then help me to show "n/a" instead. That works...however, when I have another column that looks at week over week change, when it sees the "n/a", it will calculate the week over week average to be at -100%.

Is there a way to fix the below formula to show that if the result is -100% or if the actual reported week shows "n/a", that the week over week column also shows "n/a"? Any advice is GREATLY appreciated!

=IF(ISERROR(1/(INDIRECT(ADDRESS($A260,COLUMN(INDIRECT(""&$E$4&"! "&F$4&"$3:"&F$4&"$509")),1,TRUE,"DMI"))/INDIRECT(ADDRESS($A260,COLUMN(INDIRECT(""&$E$4&"!" &J$4&"$3:"&J$4&"$509")),1,TRUE,"DMI"))-1)),"n/a",(INDIRECT(ADDRESS($A260,COLUMN(INDIRECT(""&$E$4 &"!"&F$4&"$3:"&F$4&"$509")),1,TRUE,"DMI"))/INDIRECT(ADDRESS($A260,COLUMN(INDIRECT(""&$E$4&"!" &J$4&"$3:"&J$4&"$509")),1,TRUE,"DMI"))-1))