Sum-Product in Excel You have 10 chairs at 15$ and 40 tables at 20$ and 400 napkins at 1$..... SUMPRODUCT lets you calculate the total value of it in 1 click.