I can not get the result for sumif function in vba please help

[SHIZUKA]

This is my SUMIF formula SUMIF = (rp_Recv_Detail_By_ChargeCode!A:A,Report1!A5,rp_Recv_Detail_By_ChargeCode!O:O)
Here is my code

Sub vba_sumif()

Range("I:I") = Application.WorksheetFunction.SumIf(Sheets("rp_Recv_Detail_By_ChargeCode").Range("$A:$A"), Range("A;A"), Sheets("rp_Recv_Detail_By_ChargeCode").Range("$O:$O"))

End Sub

 

[SHIZUKA]

I tried to write another way still not work
Sub Su()

MY1 = Worksheets("rp_Recv_Detail_By_ChargeCode").Range("A:A").Value
MY2 = Worksheets("rp_Recv_Detail_By_ChargeCode").Range("O:O").Value
Range("I:I") = WorksheetFunction.SumIf(MY1, Range("A5"), MY2)

End Sub

 

[johnnyL]

Is this what you want?

    Range("I:I").Formula = "=SUMIF(rp_Recv_Detail_By_ChargeCode!A:A,Report1!A5,rp_Recv_Detail_By_ChargeCode!O:O)"

 

[SHIZUKA]

Is this what you want?

    Range("I:I").Formula = "=SUMIF(rp_Recv_Detail_By_ChargeCode!A:A,Report1!A5,rp_Recv_Detail_By_ChargeCode!O:O)"

Yeah this is what I want thank you so much

 

[SHIZUKA]

Yeah this is what I want thank you so much

Hi I just realized the data is different when I run the code. it is different than I type in

 

[johnnyL]

Not sure what you mean when you say the 'data is different'.