Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2008
    Location
    Paraburdoo, Western Australia, Australia
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula to count names (2007)

    Hi can you help me to make this formula count more than one colum

    =COUNTA(A1:A215)

    I need it to count from colum A through to colum AS and I need to be able to type in a name and have is count the number of times that name appears.
    I am not even shaw that I am using the right fumula!

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to count names (2007)

    Linke to other thread corrected by HansV

    The answer was already provided by HansV in your other <!post=post,744213>post<!/post>. You just need to expand your range to include the cells you want to check.
    =countif(A1:AS1,"Sharty") or =countif(A1:AS1,B1) where B1 contains the name you looking to match.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •