Sounds like you need to modularise the problem more, which you are naturally forced to do by the limitations of spreadsheet "programming".