用EXCEL如何制定公式模板?

Design a dash board that can show: -
(i) Total Sale by Country (different year)
(ii) Sale Trend by Country / by Region
(iii) Sale Trend by Country by Quarter

Attached “Question3_data.xls” contains the data for this Question 3.
也就是说:
1。按国家（不同年度）总销售额。
2 按国家、地区销售趋势
3。按国家、季度销售趋势。

参见附件!http://bbs.smthome.net/read-htm-tid-169575.html