Hello,

I have built a table with formulas similar to this. I need assistance on
how I can create a YTD table based on what Period I select.

=SUMPRODUCT(('2010 AOPII with Benefits'!$A$1:$A$248=F$27)*('2010 AOPII with
Benefits'!$E$1:$Q$1=$C$3)*('2010 AOPII with Benefits'!$B$1:$B$248=$E28),'2010
AOPII with Benefits'!$E$1:$Q$248)-SUMPRODUCT(('2010
Actuals'!$A$1:$A$302=F$27)*('2010 Actuals'!$E$1:$Q$1=$C$3)*('2010
Actuals'!$B$1:$B$302=$E28),'2010 Actuals'!$E$1:$Q$302)

NOTE: C3 is the Period that I choose from drop down selection.

Any help is appreciated.