Formula help

[cottage6]

A user has a file consisting of 12 period sheets and 1 summary sheet. She
has a very long formula on the summary: D5*$D$2 + F5*$F$2 and so on through
column AJ. At the end of the formula she needs to add more numbers that come
from the individual period sheets: ='Per 1'!AG5*'Per 1'!AG2 and so on through
Per 12. She has a "helper" column set up that adds ='Per 1'!AG5*'Per 1'!AG2
+ 'Per 2'!AG5*'Per 2'!AG2 through Per 12. She adds the result of the helper
column to the end of the first formula. Is there a way to lose the helper
column and add a shorter 3-dimensional formula there? I'm not very good with
arrays, and I suspect we're being stupid here. TIA! Excel 2003.

 

[Jacob Skaria]

We can have another row to hold the product of D5*$D$2,..... and add up the
sum for that row.

 

[cottage6]

Thanks to both of you; I think I've figured something else out.