I have an issue in dragging the sumif formula.

I have used the formula:

=sumif(sheet1!$R$R,Sheet2!$A$3,sheet1!T:T)  sumif(sheet1!$R$R,Sheet2!$A$3,sheet1!U:U)

This gives the sum of consecutive cells .When I drag the formula only the first cell is taking the proper value remaining taking the duplicates of the previous one.

CodePudding user response：

You are using a fixed reference to sum these. Try removing the dollar signs from the second argument:

=sumif(sheet1!$R$R,Sheet2!$A$3,sheet1!T:T)

CodePudding user response：

=SUMIF(Sheet1!$B$1:$B$19,Sheet2!$B3,Sheet1!$D$3:$D$18) SUMIF(Sheet1!$B$1:$B$19,Sheet2!$B3,Sheet1!$E$3:$E$18)

This is the code which Used , Issue with this is not getting value across and also downwards values are not correct.