vba countifs 함수 "문자"

Sub U열계산()
Dim rng As Range

Dim rowsCnt As Integer
Dim Temp1 As String
Dim Temp2 As String
Dim Str1 As String
Dim Str2 As String

    rowsCnt = Cells(Rows.Count, "d").End(3).Row
    Set rng = Range(Cells(2, "F"), Cells(rowsCnt, "F"))

    Range(Cells(2, "U"), Cells(Rows.Count, "U")).ClearContents
   
    Str1 = "사입요망"
    Str2 = "출고대기"
    Temp1 = "$F$2:$F$" & Cells(Rows.Count, "F").End(xlUp).Row
    Temp2 = "$O$2:$O$" & Cells(Rows.Count, "O").End(xlUp).Row
  
    With rng.Offset(0, 15)
        .Formula = "=countifs(" & Temp1 & ",$F2, " & Temp2 & ", " & Chr(34) & Str1 & Chr(34) & ") +COUNTIFS(" & Temp1 & ", $F2, " & Temp2 & ", " & Chr(34) & Str2 & Chr(34) & ")"
        .Value = .Value
    End With
   
    Cells(2, "U").Select

End Sub