Hi Friends,

I have a big list of Client list with start and end date. It gets changed every time and I need to prepare a summary movement report. I tried on formula but it gives #VALUE! As result.

Please check and let me know what is wrong in my formula. Attd a sample sheet.

I believe SUMPRODUCT() is your needed formula. When I use it though, I get different results than you do. Either way, examine the syntax of the formula and see if:

1) my answers are actually correct... use the formulas as is
2) once you grasp the SUMPRODUCT() syntax, tweak it until you get the results you want.

Thanks JB it works