+ Reply to Thread
Results 1 to 12 of 12

Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

  1. #1
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    Can anyone translate this to a formula that can work with older versions of excel?

    XXXXXX


    -------------------------------------------------------------------
    CANCEL THAT. I need this one to work with Excel 2000. .

    =SUMPRODUCT(COUNTIF(INDIRECT({"E15","E20","E25","E30"}),">84.5"))
    Last edited by g1terra; 07-05-2017 at 02:39 AM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Need a formula to work with Excel 2002

    Edit OK. Cancel this. The question changed.

    I would expect that to work.

    What is it returning?

    In the meantime try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 07-05-2017 at 02:54 AM.
    Dave

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need a formula to work with Excel 2002

    1. Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )

    2. From what I have seen, COUNTIF() works just fine in 2002?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    Thanks for the title change

    What exactly are you trying to do there?
    Can you show some sample data and explain what you want?

  5. #5
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    I took the advice from Flameretired above and applied it to what I was trying to do and it worked. I am marking this solved. thx!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    OK, but that seems to be a work-around. COUNTIF should work for you. Can you show some sample data, and show what you get and what you expect?

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    I would like to know that, too. Hope g1terra posts back.

  8. #8
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    Ok I am attaching my sheet i need to clarify a bit more.

    I have the COUNTIF formulas highlighted in orange. I have many computers are work with excel 2000 (I know ridiculous) my laptop has 2010. I thought COUNTIF was not recognized in Excel 2000 and SumProduct had to be used? If this is not the case my sheet works with the COUNTIF. I cant check it until later in the week.

    Make sense?

  9. #9
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    Here is the attachment
    Attached Files Attached Files

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    g1terra,

    =COUNTIF(E12:E14,">84.5")

    works at my end. What results are you getting?

    And BTW I recall using COUNTIF in Office 98.

  11. #11
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    OK then I am good to go thank you!!

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need a COUNTIF formula to work with Excel 2000. Not confident it will work?

    Quote Originally Posted by FlameRetired View Post
    ...And BTW I recall using COUNTIF in Office 98.
    I kinda did, too, but wasnt sure enough to state that lol

+ 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. macro which works in excel 2000 does not work in excel 2002
    By nnayak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 09:17 AM
  2. Why won't this simple VDB script work on Excel 2002.
    By Calle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2006, 10:00 AM
  3. [SOLVED] Why won't this simple VBA script work in excel 2002?
    By Calle in forum Excel General
    Replies: 1
    Last Post: 05-29-2006, 07:25 AM
  4. Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
    By scampbell in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 02:35 PM
  5. Simple Macro, works in Excel 2002, 2003 but won't work in 2000
    By DJA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2005, 01:05 PM
  6. Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time
    By Mblackmore in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2005, 03:06 PM
  7. [SOLVED] How do I update Excel 2000 macros to work in Excel 2002?
    By BobPetrich in forum Excel General
    Replies: 3
    Last Post: 01-04-2005, 01:06 PM
  8. [SOLVED] how do i work across workbooks in excel 2002?
    By lesgold80 in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 12:06 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