Win/Loss Percent on visible rows

[Av8tordude]

This code displays my Win/Loss Percentage. I'm using an auto-filter macro to filter data and I would like to show my Win/Loss percentage on visible rows only. Can someone assist.

Thank you kindly.

With WorksheetFunction        
      CCI = Format(.CountIf(Range("P18:P" & LRow), ">" & 0) / .Count(Range("P18:P" & LRow)), "0%") & " / " & Format(1 - .CountIf(Range("P18:P" & LRow), ">" & 0) / .Count(Range("P18:P" & LRow)), "0%")
End With

 

[Av8tordude]

Can anyone assist or is this not possible?