If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MrRJ" wrote in message
...
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.