Hoping someone can help because I've been trying to figure this out for days!
I am looking to sum the cells only up to the column of the selected month: O12.
O12 is a drop down of all 12 months.
In the example below, the selected month is Apr-15 so in cell AZ20 I will need the sum of O20:Q20, columns prior to Apr-15.
If the month changes to May-15, I will need the sum of O20:R20 to sum in cell AZ20.
Thank you in advance for your help!