Mastering Yearly Summation of Values in Excel. There are two methods to sum values in Excel based on a specific year in Excel. The first method involves using a helper column, where you add a column with the year number and then sum the values based on the month from that column. The second method … Continue reading Mastering Yearly Summation of Values in Excel