To sum values specified by a year, The SUMIFS function will be used with two criteria. In our example, we will sum year wise sold units of a product.
1– Type ‘=SUMIFS’ and press ‘tab’ button.
2– Select values to sum against criteria.
3– Press ‘,‘ symbol and define the range to be tested against criteria1.
4– Specify the criteria1, that is “>=”&DATE(2018,1,1), which means sum all those units that have been sold on Jan 01, 2018 or after.