Click here to Skip to main content
14,869,839 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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)



CSS
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
Posted
Updated 11-Aug-11 8:46am
v4

1 solution

All you need to do is record a macro of you manually doing what you want and then you can see what the code is.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900