One way:

Dim n As Long
n = Application.WorksheetFunction.SumIf(Columns("A"), "<" & _
"Large Balance", Columns("B"))
MsgBox n


In article ,
StephanieH wrote:

I need to sum column B if column A does not contact the words Large Balance.
I'm not sure how or where to designate the not like part.

Application.WorksheetFunction.SumIf(Columns("A") , < "Large Balance",
Columns("B"))
returns a syntax error