how to use it with more than one function

With Range("M2")
.Value2 = Application.CountIfs(Range("I:I"), "5",("C:C"),"OPEN"
.NumberFormat = "#,##0"
End With

The problem now is M2 = #VALUE!