+ Reply to Thread
Results 1 to 6 of 6

COUNTIFS to work in Excel 2003

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    Harrogate, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    COUNTIFS to work in Excel 2003

    I have the following formula that works in excel 2007 but need it to function in 2003...and have no idea where to start...

    =IF(A4="", " ", (COUNTIFS('Chem Log'!$C:$C,A4,'Chem Log'!$J:$J,$C$1)))


    A4 = Chemical Name
    'Chem Log'!$C:$C = Column where all chemical names listed
    'Chem Log'!$J:$J = Column where the status of chemicals are
    $C$1 = the specific status that looking for such as "Opened"

    if anyone can help or suggest an alternative to the COUNTIFS function it would be great.

    Thanks
    Michael

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: COUNTIFS to work in Excel 2003

    Have you tried a pivot table
    Or sumproduct formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    02-28-2013
    Location
    Harrogate, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: COUNTIFS to work in Excel 2003

    i have tried sumproduct formula...

    what is a pivot table?

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: COUNTIFS to work in Excel 2003

    post a xls example please
    Maybe we can help you then beter

  5. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: COUNTIFS to work in Excel 2003

    Try using SUMPRODUCT like this

    =IF(A4="","",SUMPRODUCT(('Chem Log'!$C$2:$C$1000=A4)*('Chem Log'!$J$2:$J$1000=$C$1)))

    SUMPRODUCT doesn't allow you to use whole columns in Excel 2003 so I used row 2 to 1000 - adjust as required
    Audere est facere

  6. #6
    Registered User
    Join Date
    02-28-2013
    Location
    Harrogate, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: COUNTIFS to work in Excel 2003

    yeah that seems to work thanks very much daddylonglegs!

+ 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

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