The steps are as stated below: Go to Formulas >Name Manager. A Name Manager dialog box will appear. Then, click on New. Give it any name. In the Refers to box, type the following format: =GET.CELL(63,INDIRECT("rc",FALSE)) ... Finally, click Ok. 上面这个可以return每个cell的颜色、然后sumif
另外,可以用当前tab名字上的关键词做另一个总页面的查找求和么?比如tab的名字是today,用公式通过today 查找汇总页面上today对应的值
Go to Formulas >Name Manager. A Name Manager dialog box will appear. Then, click on New. Give it any name. In the Refers to box, type the following format: =GET.CELL(63,INDIRECT("rc",FALSE)) ... Finally, click Ok.
上面这个可以return每个cell的颜色、然后sumif
系统提示:若遇到视频无法播放请点击下方链接
https://www.youtube.com/embed/8FyyXMC9Jdo?showinfo=0 YouTube 教程