Results 1 to 3 of 3

Requesting count of rows that start with "abc"

Threaded View

  1. 08-27-2009, 09:06 AM #1
    JakePatuli
    JakePatuli is offline
    Registered User
    Join Date
    08-29-2007
    Posts
    6

    Requesting count of rows that start with "abc"

    I cant get LEFT to work with COUNTIF so that abcx and abcz will be counted.

    =COUNTIF((LEFT(temp.xls!B1:B4000,3)="abc"),"abc") doesnt work
    Last edited by JakePatuli; 08-27-2009 at 09:13 AM.
    Reply With QuoteRegister To Reply
« 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