最后三列为0值（即数据表为空，查找出来返回0）的时候，让0值不显示出来呢，PS：自定义格式也可以，但是日期哪一个AA列不知道该怎么定义。。。
公式：=LET(a,TRIMRANGE(明细!B3:AC10000),b,B1,c,C1,d,IFS(b="厂家",FILTER(a,TRIMRANGE(明细!D3:D10000)=c),b="日期",FILTER(a,TRIMRANGE(明细!C3:C10000)=c),b="单号",FILTER(a,TRIMRANGE(明细!G3:G10000)=c),b="全部",a),e,IFERROR(HSTACK(SEQUENCE(COUNTA(CHOOSECOLS(d,1))),d),"选择错误/未选择"),IFERROR(VSTACK(e,HSTACK("汇总：","货单方量合计:",TEXT(SUM(CHOOSECOLS(e,11)),"0.00"),"磅单方量合计:",TEXT(SUM(CHOOSECOLS(e,13)),"0.00"),"方量差:",TEXT(SUM(CHOOSECOLS(e,15)),"0.00"),"已付款金额:",TEXT(SUM(CHOOSECOLS(e,26)),"￥0.00"),"已用金额合计:",TEXT(SUM(CHOOSECOLS(e,25)),"￥0.00"),"剩余资金：",TEXT((SUM(CHOOSECOLS(e,26))-SUM(CHOOSECOLS(e,25))),"￥0.00"))),""))
公式：=LET(a,TRIMRANGE(明细!B3:AC10000),b,B1,c,C1,d,IFS(b="厂家",FILTER(a,TRIMRANGE(明细!D3:D10000)=c),b="日期",FILTER(a,TRIMRANGE(明细!C3:C10000)=c),b="单号",FILTER(a,TRIMRANGE(明细!G3:G10000)=c),b="全部",a),e,IFERROR(HSTACK(SEQUENCE(COUNTA(CHOOSECOLS(d,1))),d),"选择错误/未选择"),IFERROR(VSTACK(e,HSTACK("汇总：","货单方量合计:",TEXT(SUM(CHOOSECOLS(e,11)),"0.00"),"磅单方量合计:",TEXT(SUM(CHOOSECOLS(e,13)),"0.00"),"方量差:",TEXT(SUM(CHOOSECOLS(e,15)),"0.00"),"已付款金额:",TEXT(SUM(CHOOSECOLS(e,26)),"￥0.00"),"已用金额合计:",TEXT(SUM(CHOOSECOLS(e,25)),"￥0.00"),"剩余资金：",TEXT((SUM(CHOOSECOLS(e,26))-SUM(CHOOSECOLS(e,25))),"￥0.00"))),""))
幼儿园题目，直接if单元格为0，输出空值""就好了，或者条件格式，为0字体颜色选白色
