+ Reply to Thread
Results 1 to 2 of 2

Counting Cells with multiple criteria.One criteria supporting wild

  1. #1
    Azhar Saleem
    Guest

    Counting Cells with multiple criteria.One criteria supporting wild

    How can I count cells starting with character "C" in second column and
    related with the name John only.


    John Car
    Steve Bus
    Bush Cycle
    Powell Truck
    Bruce Van
    Bush Car
    Powell Bus
    Powell Cycle
    Bruce Truck
    John Van
    Steve Car
    Steve Bus
    Bush Cycle
    Powell Truck
    John Van
    John Cycle
    John Car


  2. #2
    Guest

    Counting Cells with multiple criteria.One criteria supporting wild


    >-----Original Message-----
    >How can I count cells starting with character "C" in

    second column and
    >related with the name John only.
    >
    >
    >John Car
    >Steve Bus
    >Bush Cycle
    >Powell Truck
    >Bruce Van
    >Bush Car
    >Powell Bus
    >Powell Cycle
    >Bruce Truck
    >John Van
    >Steve Car
    >Steve Bus
    >Bush Cycle
    >Powell Truck
    >John Van
    >John Cycle
    >John Car
    >
    >.
    >Create a third column. Insert the formula if(a1="john",if

    (left(b1,1)="c",1,0),0) Then total up the column.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1