2019-03-30计算机二级

'=VLOOKUP(D3,编号对照！$A$2:$C$19,2,FALSE)

'=VLOOKUP(D3,编号对照！$A$2:$C$19,3,FALSE)

'=F3*G3

'=SUM(订单明细表！H3:H636)

'=SUMIFS(表3【小计】，表3【图书名称】，”《MS Office高级应用》”，表3【日期】，”>=2012-1-1",表3[日期],"<=2012-12-31)

'=SUMIFS(表3[小计],表3[书店名称],"隆华书店",表3[日期],">=2011-7-1",表3 [日期],"<=2011-9-30"

'=SUMIFS(表3[小计],表3[书店名称],"隆华书店",表3[日期],">=2011-1-1",表3 [日期],"<=2011-12-31"\12