Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    countif question (excel 2003 sp2)

    I have first names listed is column "A" and last names listed in column "B". I have a counif statement in column "C" giving me a total count of each name using last name. Example-countif(B2:B300,"jones"). I have run into a problem where people have the same last name and now I need to use the first name with the last name to get the count. How can I set up my counif statement to use the first and last name and then give me a count total. I tried countif(B2:B300,"jones")+ countif(a2:a300,"steve"). This did not work. Any help would be appreciated.

    Thanks,

    Mike

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: countif question (excel 2003 sp2)

    Your countif should work it just won't give you the count of "Steve Jones"

    You can do it with the formula:
    =SUMPRODUCT((A2:A300="steve")*(B2:B300="jones"))

    Steve

Posting Permissions

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