How to Calculate the Percent of Total Sales in Excel. Monitoring sales revenue allows you to track your business' profit, but equally important is understanding where those revenues are derived ...