Results 1 to 12 of 12

Conditional counting of a string in 2 columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    The USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Conditional counting of a string in 2 columns

    Hi!

    I've searched the internet to answer my question but unfortunately had no luck. Maybe you can help me find a solution to my task.

    I know how to count how many times a string appears in a column:
    =(SUM(LEN(A1:A40))-SUM(LEN(SUBSTITUTE(A1:A40,"search string 1",))))/LEN("search string 1")

    But I need to count only if other column (eg. B) contains "search string 2". For example I want to know how many (green, red, golden) "APPLES" were sold to (Miss, missis, mister) "BROWN".

    I had a vague idea about using an asterisk for joining two "SUM" formulae. But I couldn't do it without getting an error.

    Is it possible? I'm sure there is some way.

    Can you please give me a hint how to do it?

    Thanks in advance.
    Last edited by Exboy; 06-18-2011 at 01:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1