12-month rolling turnover rate help

[Kimber]

Having trouble with a formula to calculate the 12-month rolling turnover rate for four categories. Missing some information so I am assuming I need to start formula in the 12th row of data? I've done this type of formula before but it only involved one column of data. Thank you for your help.

 

[Kimber]

Having trouble with a formula to calculate the 12-month rolling turnover rate for four categories. Missing some information so I am assuming I need to start formula in the 12th row of data? I've done this type of formula before but it only involved one column of data. Thank you for your help.

Anyone? I am stumped...and I am not an advanced Excel user. I appreciate any help!

 

[vletm]

Kimber
Do You know - how would Your '12-month rolling turnover rate' calculate?
or
what kind of help do You wait for?

 

[Kimber]

Kimber
Do You know - how would Your '12-month rolling turnover rate' calculate?
or
what kind of help do You wait for?

Hi vletm,
I think that Column L should take the total of the last 12 numbers in column H and divide it by the average of the last 12 numbers in column D.

 

[vletm]

Kimber
If You think so, then why You did something else?
I tried to write formula, which You think above ...

 

[Kimber]

Kimber
If You think so, then why You did something else?
I tried to write formula, which You think above ...

Oh, my word, vletm. Sometimes I overthink these formulas. I realize why no one offered to help right away when the answer is so simple! Thank you so much for your time and patience.