# 12-month rolling turnover rate help

#### Kimber

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

#### Attachments

• 29.3 KB Views: 11

#### Kimber

##### Member
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

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

#### Kimber

##### Member
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

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

#### Attachments

• 30.1 KB Views: 6

#### Kimber

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

Last edited: