+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS in Excel 2003

  1. #1
    Registered User
    Join Date
    Birmingham, England
    MS-Off Ver
    Excel 2007

    COUNTIFS in Excel 2003


    I need to find an alternative for COUNTIFS in Excel 2003. My current formula is =COUNTIFS(A1:A5000,2013,B1:B5000,"*John Smith*")

    Important to highlight *John Smith* as sometimes a cell in column B will contain multiple names.

    My hope is that this will also work in Google Spreadsheets as this also does not have COUNTIFS

    Much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    Bryan, TX
    MS-Off Ver
    Excel 2010

    Re: COUNTIFS in Excel 2003


    =SUMPRODUCT(--(A1:A5000=2013),--(ISNUMBER(SEARCH("John Smith",B1:B5000))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2003 - No COUNTIFS
    By westbay in forum Excel General
    Replies: 3
    Last Post: 01-18-2012, 09:29 AM
  2. COUNTIFS formula under excel 2003
    By mihait85 in forum Excel General
    Replies: 3
    Last Post: 04-05-2010, 04:23 AM
  3. Converting COUNTIFS to Excel 2003
    By John Bates in forum Excel General
    Replies: 2
    Last Post: 07-06-2009, 11:24 AM
  4. COUNTIFS equivilant in Excel 2003
    By Lotus123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2008, 08:58 AM
  5. excel's new countifs...on 2003?
    By AndyBrown in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 11:25 AM

Tags for this Thread


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