Hi,

Am Wed, 2 Sep 2015 22:44:54 +0100 schrieb Excel Dumbo:

Example- When you select "Monthly Actual" and when you select "Feb-15"-
it should give me the values for Feb 15 only, and when I select
"Mar-15", it should give me values of Mar-15.

When I select "YTD Actual" and select "Feb-15", it should give me values
from Jan-15 to Feb-15 and when i select "Mar-15", it should give me
values from Jan-15 to Mar-15

you don't need formulas in BU1 and BV1. You can calculate at once in
AB5 with:
=IF($AB$1="YTD Actuals",SUMPRODUCT(--(MONTH($P$2:$AA$2)<=$BT$2),P5:AA5),SUMPRODUCT(--(MONTH($P$2:$AA$2)=$BT$2),P5:AA5))
and copy the formula down.

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional