sql in Excel中分类求和

RISE_7

需求：根据重量划分重量区间段，并根据作业人员进行分组
在Excel中尝试执行不了，需求各位帮忙看下语句上有问题没
公示office套件加密，上传打不开，抱歉
语句如下：
SELECT
  b.复核员,
  sum( CASE WHEN a.毛重 <= 0.5 THEN 1 END ) AS a1,
  sum( CASE WHEN a.毛重 > 0.5 AND a.毛重 <= 1 THEN 1 END ) AS a2,
  sum( CASE WHEN a.毛重 > 1 AND a.毛重 <= 2 THEN 1 END ) AS a3,
  sum( CASE WHEN a.毛重 > 2 AND a.毛重 <= 3 THEN 1 END ) AS a4,
  sum( CASE WHEN a.毛重 > 3 AND a.毛重 <= 4 THEN 1 END ) AS a5,
  sum( CASE WHEN a.毛重 > 4 THEN 1 END ) AS a6,
  sum( CASE WHEN a.毛重 > 4 THEN 1 END ) AS a7
FROM
  [ C : \ Users \ Administrator \ Desktop \报表.xlsx ].[销售报表 $ ] AS a
  LEFT JOIN [ C : \ Users \ Administrator \ Desktop \报表.xlsx ].[复核报表 $ ] AS b
ON a.单据编号 = b.来源单号
GROUP BY
  b.复核员

lss001

SELECT b.复核员,sum(iif(a.毛重<=0.5,a.毛重)) as a1,sum(iif(a.毛重>0.5,a.毛重))-sum(iif(a.毛重>1,a.毛重)) as a2,......