PLease help me with formula's

[Beth]

Pleaes help me to compare the current Month vs. Average (Cell AD). I thought I
=AVERAGE(IF($R$11:$AC$11<=S2,$R$14:$AC$14))-AD14 (Not working)

2). I would also like to have a formula to do the Delta % from Current
But that is not working either. The original formula I was using is

=1-(AC14/AD14) but that would mean I have to manually change this as well.
Wasn't wanting to do that...

Thanks.

 

[Don Guillett]

Not working means?
Did you array enter the array formula?

 

[Beth]

Not working means I am unable to populate a formula that will change my
current month cell vs. average cell when changing from month to month without
manually having to enter in a formula for each month. I was hoping to have a
formula automatically populate information like I had done so with the
average cell (see beginning of this message). I did try to array the formula
but it is not working, I do not get the right number.

As for my 2nd question with Delta, same response above as to not working.
Does this make sense?
Thanks,
--
Beth

Not working means?
Did you array enter the array formula?

 

[John Michl]

I believe I answered this in a different thread titled
Averages-HLOOKUP??.

- John