Hi,
I have a workbook with following formula in cell G3 in Sheet1 which is referencing Sheet2. When I try to copy this formula to cell C3 in Sheet1, the relative cell reference part is the same as source and won’t ajust…...G$3:G$7,Sheet2!$B$3:$B$7,Sheet1!$B3) I am expecting...=SUMIFS(Sheet2!C$3:C$7,Sheet2!$B$3:$B$7,Sheet1!$B3) AsposeTest.zip (19.1 KB)...