On Jan 3, 10:44*am, Dave F wrote:
SUM('GDCS Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E5:P5,0),,) +4))-'GDCS
Act_FCST'!AK8

Sorry, posted this before I asked the question.

The formula '=ADDRESS(8,INDEX(MATCH(AO5,E5:P5,0),,)+4) returns $P$8.

When I try to insert it into my large formula, like this: SUM('GDCS
Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E5:P5,0),,) +4))-'GDCS Act_FCST'!
AK8

I get an error.

Thoughts?