av8tordude
08-09-2019, 03:24 AM
How can I make this Countif and Count work when rows are filtered?
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
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