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

The below formula will return the projected YTD total:

=N2/COUNTA(B2:M2)*12

Where: n2 contains the Actual YTD Total
and B2:M2 contains monthly amounts.

The COUNT() function returns the count of numbers in the referenced range.

Ron C

Hello,

Try:

=AVERAGE(B2:M2)*12

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

Regards,
Nate Oliver

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
>.
>