Sorry i didnt see the Sum worksheet embedded in the first post (its normally at the bottom of the post)

So you just want the sum of Price quantity and freight?

First tip - dont merge cells, they will play havoc with formulas and vba