SOLVED

Relating formula between 2 worksheets

Brass Contributor
4 Replies

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

NIL

best response confirmed by Dharmendra_Bharwad (Brass 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.

 

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.
1 best response

Accepted Solutions
best response confirmed by Dharmendra_Bharwad (Brass 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.

 

View solution in original post