SOLVED

Relating formula between 2 worksheets

Highlighted
Contributor
4 Replies
Highlighted

@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.

Highlighted

NIL

Highlighted
Best Response confirmed by Dharmendra_Bharwad (Contributor)
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.

 

Highlighted
Lol! It was so basic. I bothered you for that. Thanks alot for everything. Would love to get help repeatedly from stalwart like you. Thanks.