在Excel工作表中提供公式的问题-带宏的Excel自动化. [英] Problem for giving formulas in excel sheet - Excel automation with macro.

问题描述

我正在使用宏进行Excel(MS-Excel 2007)自动化，我想在一个单元格中添加一个公式.我的工作簿包含3张纸，我在第3张纸的单元格中写的公式，是指从前两张纸的值中提取结果值.我已经将公式直接赋予了"fx"区域，但它显示了一些错误或卡住的问题，因此我尝试了数据合并"选项(用于使前两张纸对第三张纸的引用)，但我很怀疑在我正在做的事情上是正确的！而且我在合并选项中遇到了数据参考问题.请帮助我解决此问题.

请注意要放入单元格中的公式.

I am doing excel( MS-Excel 2007 ) automation using macro,I want to add one formula in one cell. My workbook contains 3 sheets, the formula I am writing in the cell of 3rd sheet, I mean the result value is extracted from values from first two sheets. I have given the formula stright to the ''fx'' area but it shows some error or stuck up problem so I tried with Data consolidate option ( for making the first two sheet''s reference to the 3rd sheet ) but I am doutful on what I am doing is right!! and I am facing data reference issues in consolidation option. Please help me to solve this issue.

Note the formula that I want to put into the cell.

=SUMIFS(Jr_Weekly_Status_report_9220!$K:$K,Jr_Weekly_Status_report_9220!$C:$C,
Sum!$C$2,Jr_Weekly_Status_report_9220!$L:$L,Sum!D$1,
Jr_Weekly_Status_report_9220!$J:$J,Sum!$B$1)

Sheet Names in the work book :
 ----------------------

Sheet 1 : Jr_Weekly_Status_report_9220

Sheet 2:  NumberSheet

sheet 3 : Sum

This formula I am putting in this cell of sheet-3 : Sum

推荐答案

K:

K，Jr_Weekly_Status_report_9220！

K,Jr_Weekly_Status_report_9220!

C:

这篇关于在Excel工作表中提供公式的问题-带宏的Excel自动化.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！