Results 1 to 3 of 3

Multiple conditions in counting

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2015
    Location
    Seattle
    MS-Off Ver
    2008 for Mac
    Posts
    3

    Multiple conditions in counting

    Hi guys-

    I'd appreciate a second set of eyes on a problem. I have a huge data sheet on Farmer's Markets throughout the United States. I have to find out how many farmers markets there are per capita in each state. The catch is that I must exclude all Farmer's Markets in cities with more than 1 word in their name. I used a Len(Trim) equation to give me values for the number of words in the city name so it looks like this:

    Screen shot 2015-07-07 at 2.54.06 PM.png
    Attached Images Attached Images
    Last edited by jduffy0920; 07-18-2015 at 12:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting with multiple conditions
    By liln5k in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2014, 08:10 PM
  2. Counting with multiple conditions
    By BradDenton in forum Excel General
    Replies: 8
    Last Post: 05-31-2012, 03:37 PM
  3. Counting multiple Conditions
    By Joeysparrow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2012, 08:50 PM
  4. Counting multiple conditions
    By Sippy69 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2008, 09:12 PM
  5. Counting with multiple conditions
    By Littleoladywho in forum Excel General
    Replies: 4
    Last Post: 09-19-2007, 04:40 PM

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