Hi,
I am creating a trend analysis spreadsheet. I have set up columns
Jan-Dec(Cells R12-AC12), Average(AD), Current Monthly amount vs. average(AF),
Delta (AG), YTD Actuals, YTD Budget, etc. etc.
Within this sheet I have created a formula in cell Q2 to make the data
within change per month. The formula is:
=CHOOSE($Q$2,R12,S12,T12,U12,V12,W12,X12,Y12,Z12,A A12,AB12,AC12). So when I
change the # in cell Q2, 1=Jan, 2=Feb, 3=Mar, etc. My Question is, I'm
trying to create averages based on the month I am in. If I am in February
(by hitting 2 in cell Q2), I want the avg. to calculate: Sum Jan + Feb /2 =
answer, if I am in May (by hitting 5 in Q2), I want it to calculate
Jan:May/5...I thought maybe Hlookup, but that isn't working for me? If I
manually type this in =Sum(R14:R15)/2=it stays the same when I change the
month within Q2-which means I would have to do a control F and replace
everytime I want a different month as opposed to having a formula.
Does this make sense?
Thanks so much in advance!
--
Beth