+ Reply to Thread
Results 1 to 5 of 5

possible COUNF IF fomula issues

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    Northampton, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    possible COUNF IF fomula issues

    Hi,

    I am trying to add a formula that will find, Cell A1(sheet1) in sheet 2 column A

    And then for it to count how many 'Perfect' for cell A1(same as above) are in Column G(on sheet2)

    I have tried COUNTIF/ SUMPRODUCT/ LOOKUPS and it keeps adding the number of times Cell A1 shows up along with the number of Times "perfect" can be found.

    Any help will be appricated

    Thanks
    Last edited by Kirstie1991; 03-27-2014 at 04:38 PM.

  2. #2
    Registered User
    Join Date
    03-27-2014
    Location
    Northampton, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: possible COUNF IF fomula issues

    I would like it to read something like

    =countif((Sheet!2A:A,=Sheet1!A1)"only if"(Sheet2!G:G,="Perfect"))

    I hope this helps people to undrestand what i am trying to acheive.

    Thanks
    Ps. getting frustrated

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: possible COUNF IF fomula issues

    Maybe this formula in Sheet1:

    =COUNTIFS(Sheet2!A:A,A1,Sheet2!G:G,"Perfect")
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    03-27-2014
    Location
    Northampton, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: possible COUNF IF fomula issues

    THANKS

    I cant believe it is that simple.... :D made my day

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: possible COUNF IF fomula issues

    You're welcome! Thanks for the rep, and thanks for marking your thread Solved!

+ 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. Data Validation List Issues/Sorting Issues
    By taylorbe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2014, 09:53 AM
  2. help with formula reqiured,
    By tabbitt in forum Excel General
    Replies: 1
    Last Post: 04-08-2012, 05:37 AM
  3. Need fomula
    By kenzo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2006, 01:35 PM
  4. [SOLVED] Fomula
    By Steve in forum Excel General
    Replies: 2
    Last Post: 12-08-2005, 03:35 PM
  5. Please help, i need a fomula
    By Age Formula?? in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2005, 06:05 PM

Tags for this Thread

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