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.

SUMPRODUCT function