SUMIFS formula not working in VBA

Hello all,

Forgive me if this is confusing, it's my first post.

I have the following string in VBA:

If RVR.country1.Value = True Then
    Sheets("Graphical Overview").Range("B90").Value ="=SUMIFS('DataExport(1)'!$E:$E,'DataExport(1)'!$X:$X,$A90,'DataExport(1)'!$W:$W,B$89,'DataExport(1)'!$K:$K," <> "&7)"
End If

If RVR.region1.Value = True Then
    Sheets("Graphical Overview").Range("B90").Value = "=SUMIFS('DataExport(1)'!$E:$E,'DataExport(1)'!$X:$X,$A90,'DataExport(1)'!$W:$W,B$89,'DataExport(1)'!$K:$K,$C$83)"
End If

If RVR.state1.Value = True Then
    Sheets("Graphical Overview").Range("B90").Value = "=SUMIFS('DataExport(1)'!$E:$E,'DataExport(1)'!$X:$X,$A90,'DataExport(1)'!$W:$W,B$89,'DataExport(1)'!$Q:$Q,$C$83)"
End If

If RVR.org1.Value = True Then
    Sheets("Graphical Overview").Range("B90").Value = "=SUMIFS('DataExport(1)'!$E:$E,'DataExport(1)'!$X:$X,$A90,'DataExport(1)'!$W:$W,B$89,'DataExport(1)'!$A:$A,$C$83)"
End If

Everything works perfectly, except the portion in red.

It worked fine outside of VBA in an empty cell, but once transferred to VBA, it returns FALSE. Am I missing something?

Thanks in advance for the help.