Anyone know how to sumif 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

 

[Joe4]

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

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.