Count of Records IF

[arnelgp]

can you use macro-enabled workbook (xlsm)?

Public Function fnCountHowManyLongLines(ByVal rng As Range) As Long
    Dim arr As Variant
    Dim i As Long, j As Long
    Dim s As String
    Dim cnt As Long    
    arr = rng    
    For i = 1 To UBound(arr, 1)
        s = ""
        For j = 1 To UBound(arr, 2)
            s = s & arr(i, j) & ""
        Next
        cnt = cnt + Abs(Len(s) > 256)
    Next
    fnCountHowManyLongLines = cnt
End Function

based on your demo xlsm, put the formula on any cell:

=fnCountHowManyLongLines(A2:B3)

result: 1