Quick question:
I've currently developed a data base with monthly sales to calculate YTD depending on a specific date chosen from a dropdown menu.
Formula is as follows:
Where $L$1 is a droplist from which you can choose a date
$BH$3:$DD$3 is where the months are referenced
And $BH$4:$DD$4 is where the monthly sales are available
Now I would like to apply the same principle except divide each month by a number that is also available monthly in order to get the YTD of that ratio.
I know it can be easily done by simply recalculating monthly averages (i.e. Monthly Sales / Number of that same month) and then adding them up with the same formula as above but i'd really like to avoid doing that.
Any ideas?
Bookmarks