Need VBA code to SumIf criteria is met in another column

[mslynng]

I need to SUM the $ Amounts in column B but only include $ Amounts when Column A has "Closed" as the status. Can you help me please? I have been trying for 2 days.

myLastColumn = .Cells(1, Columns.Count).End(xlToLeft).Column
myLastRow = .Cells(Rows.Count, 1).End(xlUp).Row

ReqAmt = Range("N" & Rows.Count).End(xlUp).Row
If ReqAmt < 2 Then RecAmt = 2
Range("V2") = Application.WorksheetFunction.SumIf(Range("N2:N" & ReqAmt), "Closed","O2
Cells(1, myLastColumn + 1).Value = "$ Requested"

[TMS]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I don't quite see the relevance of your code example to the question you are asking.

Regards

[abousetta]

Hi,

Try change this line:

Range("V2") = Application.WorksheetFunction.SumIf(Range("N2:N" & ReqAmt), "Closed","O2

to

Range("V2") = Application.WorksheetFunction.SumIf(Range("A2:A" & ReqAmt),"Closed",Range("B2:B" & ReqAmt))

abousetta

[abousetta]

Sorry @TMShucks, I didn't see your post until after I posted. Would you like to delete my post?

abousetta

[TMS]

@abousetta: don't worry about it.