Lifetime value of a contract

Originally Posted by ammartino44

Can you re-attach the spreadsheet with your calculation.

Why?

Originally Posted by ammartino44

You have nothing in H2.

Originally Posted by ben_hensel

H2 =SUM(E2:E29)

Originally Posted by ammartino44

Also, 2.1815 years seems rather small, no?

Over 75% of your contracts ended in one year, so I thought it looked intuitively correct.