Formula Extension

Hi,   I am wanting some help with a complex formula. I need to extend the formula to cover from 60 columns to 500 and the only way I can think of doing it is typing in the formula cell by cell. Is ...