1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Counting strings in one column based on Condition in another column in Excel

Discussion in 'Business Applications' started by MJFLIPPO, Dec 28, 2000.

Thread Status:
Not open for further replies.
Advertisement
  1. MJFLIPPO

    MJFLIPPO Thread Starter

    Joined:
    Jun 22, 2000
    Messages:
    54
    I need some help. I am trying to come up with a formula that counts the times that a "string" occurs based on a value in another column.....
    Example:
    Everytime column a = "Jones", check if column e = "tom".....if so count it.
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    The EASY way to do this is to concatenate columns A and E using (for instance) this formula:

    =A1&E1

    or

    =A1&" "&E1 (puts a space between two words)

    Then count the individual field. Make sense? Will it work for you?

    ------------------
    ~dreamboat~
    Brainbench MVP for Microsoft Word
    Brainbench
     
  3. MJFLIPPO

    MJFLIPPO Thread Starter

    Joined:
    Jun 22, 2000
    Messages:
    54
    Thanks, I believe that will work for me....
     
  4. Mulderator

    Mulderator

    Joined:
    Feb 20, 1999
    Messages:
    51,022
    There she goes with that "concatenate" again--she loves that word!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Counting strings column
  1. csweezy
    Replies:
    15
    Views:
    861
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/38217

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice