hi,
I have written the following formula in R1C1 style :
=IF(ISERROR(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)),"-",(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)))
But after generating the sheet, the formula got changed.
=IF(ISERROR(SUMIFS('Daily Raw Data '!C49 : C[44],'Daily Raw Data '!C2 : C[-3],'Associate Scorecard'!R9C,'Daily Raw Data '!C6 : C[1],'Associate Scorecard'!R1C24)),"-",(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)))
I highlughted yellow, how the formula is changing.
So, please can any one suggest why this is happening and please provide the solution and sample code for this issue.
Thanks,