Results 1 to 5 of 5

Sumproduct to Count Text

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Sumproduct to Count Text

    Hello everyone, and thanks in advanced for your help. Here is my problem:

    I have Excel 2003 at my office and I am trying to use the sumproduct function to count the number of times certain text appears. I receive data weekly which contain the names of firms that we do business with. Sounds easy enough, but the problem is that sometimes the firms are listed differently (eg. ABC Inc; ABC, Inc.; ABC). My solution was to add another sumproduct term, but I am unsure if the data will show an alternate firm name in the coming weeks.

    Is there a way to use sumproduct to count all the cells of text that contain the phrase "ABC" indeterminate of what else is in the cell?

    Current formula: =SUMPRODUCT(--(Data!A2:A3000="person")*(--(Data!G2:G3000="ABC")+(--(Data!G2:G3000="ABC, LLC"))+(--(Data!G2:G3000="ABC LLC"))))

    Preferred formula: =SUMPRODUCT(--(Data!A2:A3000="person")*(--(Data!G2:G3000=("cell contains ABC")))

    Thank you again for your expertise.
    Last edited by jnweiss; 04-09-2012 at 09:14 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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