is this correct? I get an answer of 0
With Range("AE2")
.Value2 = Application.CountIfs(Range("N:N"), "4", Range("G:G"), "OPEN", Range("O:O"), ">0")
.NumberFormat = "#,##0"
End With

But with this in a cell I get an answer of 4
=COUNTIFS(G:G,"OPEN",N:N,"4",O:O,">0")