04-10-2020 01:00 AM - edited 06-15-2020 07:42 PM
04-10-2020 02:41 AM
@Dharmendra_Bharwad Noticed that the row headers on B and C were not in the same order as in A. Perhaps you did this on purposes, but it makes solving your problem a lot more difficult. So, I changed that and offer you the simpler solution in sheet A. It uses SUMPRODUCT and two extra date fileds to also determine the start and end of year you want to sum.
04-10-2020 03:39 AM