You can calculate ACoS in Excel using the formula = Total Sponsored Products Spend / Total Sponsored Products Sales * 100. Plug in the total ad spend and revenue amounts for the date range.