Automate Run Rate Formula

[Juan]

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

 

[Nate Oliver]

Hello,

Try:

=AVERAGE(B2:M2)*12

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

Regards,
Nate Oliver

 

[jUAN]

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