Sum at Table Column - Stop Macro if value is zero

[gberg]

I have "Table1" that has a header named "Totals". I am trying to create a VBA code that summarizes the total value of the "Totals" column within the VBA code and if it is zero then stops the code but if it has any other value, it continues the code.

Hope someone can help

 

[StephenCrump]

Perhaps:

If Evaluate("SUM(Table1[Totals])") = 0 Then
    'Do things
End If

Not sure whether you might want to round, to avoid small differences between the total and zero?

 

[gberg]

Stephen, That worked great! Thanks for your help!