请EXCEL高手帮帮忙,如图所示: 如何用公式提取月统计表中的某周数据答:从E16开始,第一至五周公式:=SUM(OFFSET($E5,0,0,1,8-WEEKDAY($E$1&"-"&$G$1&"-1",2)))=SUM(OFFSET($E5,0,0,1,15-WEEKDAY($E$1&"-"&$G$1&"-1",2)))-SUM($E16:E16)=SUM(OFFSET($E5,0,0,1,22-WEEKDAY($E$1&"-"&$G$1&"-1",2)))-SUM($E16:F16)=SUM...