Forum Discussion
Formula that will update values as actuals are entered
Hi, I have a formula query for everone out there. I have a budget which is pulled from a separate tab laying out the dates and values (see columns A-F) This is then spread evenly across the period...
Hi,
You may try
=($F5-SUMIFS($H15:O15,$H$13:O$13,">="&$B5,$H$13:O$13,"<="&$C5))/(YEARFRAC(P$13,$C5)*12+1)*($B5<=P$13)*($C5>=P$13)
Please see in attached file.