主题：请求帮助！

授人以鱼，不如授人以渔。5楼公式：

sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工1","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工2","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工3","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工4","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工5","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工6","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工7","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工8","=",GridName)

用Eval（）来简化，步骤如下。

 第一步：简化成以下格式：

sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工

1","=",GridName)+sumfor("A拉数据录入表","人均净工费","日期","=",[日期],"员工姓名_员工

……

8","=",GridName)

红色一段称为头部，蓝色一段为中部，紫色一段为尾部。

Eval（）函数公式写法如下 。

第二步：列出函数：

Eval（""）

第三步：改写头部，规则是用""替代"，并写入函数内：

Eval（"sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工"）

第四步：在头部末加入替换函数 Substitute()，格式为"+Substitute("","","")+"：

Eval（"sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工"+Substitute("","","")+""）

第五步：填充替换函数公式。第一个双引号中列入变量，此处为1、2……7、8，格式为：1|2|3|4|5|6|7|8;第二个双引号中写入变量分隔符|；第三个双引号中写入前面说的中部，但中部所有"也要改写为""：

Eval（"sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工"+Substitute("1|2|3|4|5|6|7|8","|",""",""="",GridName)+sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工")+""）

第六步：写入尾部，也是要把所有"也要改写为""：

Eval（"sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工"+Substitute("1|2|3|4|5|6|7|8","|",""",""="",GridName)+sumfor(""A拉数据录入表"",""人均净工费"",""日期"",""="",[日期],""员工姓名_员工")+""",""="",GridName)"）

这样，整个公式就完成了。楼主可以试试看。6楼公式因为没看到文件，对其中一些数据关系不清楚，所以无法回复。

先检验原始公式是否正确（不用写那么多，就一、 两个变量就行），再套用这个方法。