First go to “Reports” -> “Sales Reports”
Then got to “Territory Sales Report”
The Select your Territory and “Include Sub Territory”. Select “Won” under “Opportunity Status”. Select “Screen” for the Display options and press “Go”:-
Currently you can not export to Excel. I am told that this will be fixed in the next Sage CRM version, due at the end of April 2012.
Once you report displays on screen copy and paste this into Excel and add your formulas.