Sumifs calculations

[Johnyam54]

Hi team,

Could someone please assist me to review the attached file to come up with a correct formalar to calculate over payment after the lease expired by months so i will know the total over payments.

thanks

[AliGW]

In L5 copied down:

=SUMPRODUCT($F5:$K5*(MONTH($F$4:$K$4)>MONTH(D5)))

[FlameRetired]

Please try this formula in L5 and copy down

Please Login or Register  to view this content.

Having said that there are inconsistencies in the header dates in row 4. These may be causing some problems although this formula works with what you have provided.

[Johnyam54]

Hi AliGW,
Thank you so much for your help. have a great weekend..

[Johnyam54]

Thanks very much Dave for your help..

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[FlameRetired]

Glad to have helped Johnyam54. Thank you for the feedback.