Why did I ask you to reupload the spreadsheet with your calculations? Well, you have this formula H3 =SUMPRODUCT(A2:A29,E2:E29)/H2 yet there is no value in H2 in the spreadsheet that I attached. Yeah, 75% of the contracts end after one year, but the remaining % have a very high life span (80+% renew).