Hi Carim,

I am not quite sure what you mean by allocation key (somewhat new to
this). I tried to simplify what I showed to make it easier. If it is
needed, I can put the total number of months in a different cell. That
way, I only have to divide the amount and the cell with the total
months calculated. However, if there is a way to count and allocate
within the same formula, that can work as well. Essentially I am trying
to:
1. Find the total months within all phases (which can already be
calculated in another cell)
2. Divide the Amount by the the total months.
3. Allocate that cost to the months that are within the multiple date
ranges.

Does this help? Thanks again!

Cheers,

Dan

Carim wrote:
Hi Dan,

Could you be a bit more precise regarding your allocation key ?
It looks as if it is only the total amount divided by a variable number
of months ...

Cheers
Carim