求2024年1月1日至现在(now)顾客的消费总积分写的宏代码如下
Sheet6.Cells(57,5)= Application.WorksheetFunction.SumIfs(Sheet2!Bn6:Bn198), "Sheet2!BL6:BL198",">n", "Sheet2!BL6:BL198","<m")
n是起始时间点;m是结束时间点;Sheet2!Bn6:Bn198是顾客消费积分区域,Sheet2!BL6:BL198是顾客消费时间区域
运行时显示“语法错误,编译错误”
请指出Sheet6.Cells(57,5)= Application.WorksheetFunction.SumIfs(Sheet2!Bn6:Bn198), "Sheet2!BL6:BL198",">n", "Sheet2!BL6:BL198","<m")中的错误,谢谢
Sheet6.Cells(57,5)= Application.WorksheetFunction.SumIfs(Sheet2!Bn6:Bn198), "Sheet2!BL6:BL198",">n", "Sheet2!BL6:BL198","<m")
n是起始时间点;m是结束时间点;Sheet2!Bn6:Bn198是顾客消费积分区域,Sheet2!BL6:BL198是顾客消费时间区域
运行时显示“语法错误,编译错误”
请指出Sheet6.Cells(57,5)= Application.WorksheetFunction.SumIfs(Sheet2!Bn6:Bn198), "Sheet2!BL6:BL198",">n", "Sheet2!BL6:BL198","<m")中的错误,谢谢