Results 1 to 22 of 22

Formula to lookup Multiple Column Text and then Count Result

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2005
    MS-Off Ver
    2013
    Posts
    23

    Formula to lookup Multiple Column Text and then Count Result

    Hi,

    I am trying to figure out this problem and I hope you can help me out.

    I have 2 columns in Sheet1, column E is called "Colors" and column f is called "Model"

    I want the formula result to be in sheet 2, cell A1

    For example, The formula will look for "Legend Lime" in the column e and "GT" in column F and place the all the Legend Lime GT's in Sheet 2, Cell A1, as a number (quantity)

    Then in Sheet 2, Cell A2, the Legend Lime V6's and so on
    Example
    Column E (Colors)
    z Unknown
    Redfire
    Legend Lime
    Mineral Grey
    Sonic Blue
    Black
    Black
    Redfire
    Legend Lime
    Mineral Grey
    Black


    Column F (Model)
    GT
    GT
    V6
    GT
    V6
    GT
    Roush
    GT
    GT

    Thank You for any assistance that you can provide!
    Last edited by ShelbyMan; 08-21-2005 at 11:14 AM. Reason: Spelling

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