+ Reply to Thread
Results 1 to 22 of 22

Formula to lookup Multiple Column Text and then Count Result

  1. 08-21-2005, 11:13 AM #1
    ShelbyMan
    ShelbyMan is offline
    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
    Reply With QuoteRegister To Reply
  2. 08-21-2005, 01:05 PM #2
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  3. 08-21-2005, 08:43 PM #3
    ShelbyMan
    ShelbyMan is offline
    Registered User
    Join Date
    08-21-2005
    MS-Off Ver
    2013
    Posts
    23
    Thank You Chris!

    Worked like a charm....

    I very much appreciate you help
    Reply With QuoteRegister To Reply
  4. 09-05-2005, 10:05 PM #4
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  5. 09-05-2005, 11:05 PM #5
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  6. 09-06-2005, 12:05 AM #6
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  7. 09-06-2005, 01:05 AM #7
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  8. 09-06-2005, 02:05 AM #8
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  9. 09-06-2005, 03:05 AM #9
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  10. 09-06-2005, 04:05 AM #10
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  11. 09-06-2005, 06:05 AM #11
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  12. 09-06-2005, 07:05 AM #12
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  13. 09-06-2005, 09:05 AM #13
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  14. 09-06-2005, 10:05 AM #14
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  15. 09-06-2005, 11:05 AM #15
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  16. 09-06-2005, 12:05 PM #16
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  17. 09-06-2005, 02:05 PM #17
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  18. 09-06-2005, 03:05 PM #18
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  19. 09-06-2005, 04:05 PM #19
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  20. 09-06-2005, 05:05 PM #20
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  21. 09-06-2005, 06:05 PM #21
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
  22. 09-06-2005, 07:05 PM #22
    Blue Hornet
    Guest

    Re: Formula to lookup Multiple Column Text and then Count Result

    This is what SUMPRODUCT is for.

    On Sheet2, A1, the formula would be:
    =SUMPRODUCT((( Sheet1!$E$1:$E$10) = "Legend Lime") * ((
    Sheet1!$F$1:$F$10) = "GT"))

    Of course, it's much more convenient for the "Legend Lime" and "GT" to
    be cell references, so the formula can be copied down a number of rows,
    etc. But I think you get the idea.

    Chris

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1