[已解决]请教老师，应如何修改公式，谢谢

huangjinyui

="共"&COUNTIF(关联表!C:AZ,$C$3&"*")&"节"
如公式中的区域     关联表!C:AZ
要修改为区域      
关联表!AQ:AV,关联表!AG:AM,关联表!W:AC,关联表!M:S,关联表C:I

请教各位老师，该如何修改更好，谢谢！

最佳答案

月排行榜 / 总排行榜

cbg2008

2013-3-21 09:48

1032446692 发表于 2013-3-21 09:33
老师  你这种方法显然不行  indirect的参数太多了

谢谢提醒，刚才公式没有经过验证应该是
="共"&SUM(COUNTIF(INDIRECT("关联表!"&{"AQ:AV","AG:AM","W:AC","M:S","C:I"}),$C$3&"*"))&"节"

跳转到最佳答案楼层

业余爱好者

还是上附件比较好一点

youfang

这么多区域还是自定义名称吧

cbg2008

="共"&SUM(COUNTIF(INDIRECT("关联表!AQ:AV","关联表!AG:AM","关联表!W:AC","关联表!M:S","关联表C:I
",$C$3&"*"))&"节"

1032446692

cbg2008 发表于 2013-3-21 09:17
="共"&SUM(COUNTIF(INDIRECT("关联表!AQ:AV","关联表!AG:AM","关联表!W:AC","关联表!M:S","关联表C:I
",$C ...

老师  你这种方法显然不行  indirect的参数太多了

cbg2008

1032446692 发表于 2013-3-21 09:33
老师  你这种方法显然不行  indirect的参数太多了

谢谢提醒，刚才公式没有经过验证应该是
="共"&SUM(COUNTIF(INDIRECT("关联表!"&{"AQ:AV","AG:AM","W:AC","M:S","C:I"}),$C$3&"*"))&"节"

huangjinyui

谢谢各位老师，谢谢