1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Easy excel formula question

Discussion in 'Windows & Other Software' started by A[L]C, 5 Mar 2006.

  1. A[L]C

    Soldato

    Joined: 18 Oct 2002

    Posts: 7,486

    Location: Maidenhead

    What is the formula to count how many cells are populated with data?

    ie I have a list of names and want to count how many names are in a range

    Thanks
     
  2. A[L]C

    Soldato

    Joined: 18 Oct 2002

    Posts: 7,486

    Location: Maidenhead

    found it

    =COUNTA(B2:B27)