Automate Run Rate Formula
 

Hi,
I have a sheet with following:
col B-M Col N Col O have a run rate formula
Per 1 -Per 12 Ytd total =(N2/1)*12 (Which this is based
on ytd with only per 1.

So each month there will be data for each period and YTD
will be based on those periods of data. So I would need to
manually go into the formula and add period example
for period 2 would =(N2/2)*12, per 3 =(N2/3)*12 etc. Is
there like a automatic way to do this?

HOpe I'm clear. Please provide any feedback,
appreciate any help.

Thanks,
juan

Automate Run Rate Formula
 

Hello,

Try:

=AVERAGE(B2:M2)*12

Assuming that months with no data are empty (do not hold values of 0).

Regards,
Nate Oliver

Automate Run Rate Formula
 

Hello Nate,
thanks for the info. I think this should work. Just need
to make sure as you mention regarding values of 0.
Appreciated the help.

Thanks again,

Juan
-----Original Message-----
Hello,

Try:

=AVERAGE(B2:M2)*12

Assuming that months with no data are empty (do not hold
values of 0).

Regards,
Nate Oliver
.