Hi,

I am trying to find a way to simplify the nested if i wrote below. I want my calculation to be done based on the date I input. My values are stored in a table as follows:

Jul-13 Aug-13 Sep-13 Oct-13............Total
Value1 Value2 Value3 Value4........ Sum(n0:n+k)

A1: Input Date

=IF($A$1="Jul-13",SUM(Q4),IF($A$1="Aug-13",SUM(Q4:R4),IF($A$1="sep-13",SUM(Q4:S4),IF($A$1="Oct-13",SUM(Q4:T4),IF($A$1="Nov-13",SUM(Q4:U4),IF($A$1="Dec-13",SUM(Q4:V4),IF($A$1="Jan-14",SUM(Q4:W4),IF($A$1="Feb-14",SUM(Q4:X4),IF($A$1="Mar-14",SUM(Q4:Y4),IF($A$1="apr-14",SUM(Q4:Z4),IF($A$1="May-14",SUM(Q4:AA4),IF($A$1="Jun-14",SUM(Q4:AB4),"Error, Please Check Date"))))))))))))

Regards,

ME