Count number of cells with more than 3 charactors

  • Hi


    Hopefully an easy one, I am trying to count across a row the number of times a cell contains more than 3 charactors.


    I have tried count if with a Len function and a sumproduct but keep getting a #value error returned.


    Thank you


    Jeff

  • Here is a VBA solution for you assuming your data starts in cell A1


  • Hello,


    What formula are you using ...???


    Have you tried :

    Code
    =SUMPRODUCT(N(LEN(A1:Z1)>3))


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Glad you could fix your problem ...:)


    Thanks for your Thanks ... AND for the Like :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!