Apr 10 2020 01:00 AM - edited Jun 15 2020 07:42 PM
Apr 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.
Apr 10 2020 03:28 AM
Solution@Dharmendra_Bharwad Moved the first and last date of the year to the hidden column H and they are now "calculated" by the DATE function, based on the date in C2.
Apr 10 2020 03:39 AM
Apr 10 2020 03:28 AM
Solution@Dharmendra_Bharwad Moved the first and last date of the year to the hidden column H and they are now "calculated" by the DATE function, based on the date in C2.