Since you are using calculated values, you will be unable to use the sum function properly. There are two options you can do, A) add a condition to your sum formula (you'll also need to include the quantity column here), or B) use an unused column which will hold the total value per row, which you can easily use for the sum function. Is this ...