主题：求帮忙分析改良公式

列刷新公式
sumfor("加工中心机床运行记录","合格数量","日期", "=" ,"2011-11-8","班次", "=" ,"白班","机床编号", "=" , [机床])
运行正常
现在想专门做一个表用于保存日期，也为了方便以后日期的变更。新加的表只有“序号”“日期”两列
现变更列刷新公式为
①sumfor("加工中心机床运行记录","合格数量","日期", "=" ,Cell(28,2,"转换月日期表"),"班次", "=" ,"白班","机床编号", "=" , [机床])
或者
②sumfor("加工中心机床运行记录","合格数量","日期", "=" ,FindText("转换月日期表","日期","序号", "=" ,"23"),"班次", "=" ,"夜班","机床编号", "=" , [机床])

发现公式都不能运行。求解决方案。希望大虾门多多指教！

egd文件下载