Calculating YTD percentages in Excel isn’t always straightforward, but in some cases you can use Excel’s most flexible function to achieve the result you need. Let’s have a look at the statistics below. The Loss % cannot be averaged over the period because the volumes vary across the months. We need to do a calculation … Continue reading YTD Percentages in Excel