第二套Excel函数SUMIFS问题
=SUMIFS(SUMIFS(SUMIFS(SUMIFS())))+SUMIFS("订单明细表!",订单明细表!B3:B636,">=2012-01-01",订单明细表!B3:B636,"<=2012-12-31",订单明细表!C3:C636,"《MS Office高级应用》")
=SUMIFS(表3[小计],表3[图书名称],"《MS Office高级应用》",表3[日期],">=2012-01-01",表3[日期],"<=2012-12-31")
先筛选图书名称,在筛选日期