Results 1 to 2 of 2

Thread: Help, i'm stumped
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help, i'm stumped

    Just looking for a little help with this formula as I cant seem to get it to work. Basically I'm looking to return an F if the "PP - 3" is greater than 0. Returning a P if "pp - 1" + "PP - 2" is greater than 0 and if when you add all three together it returns a 0 then leave the cell bank.


    If there are results greater than 0 in the first two calculations, then the F overrides the P.



    Here is what I have so far.



    =IF(COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 3**") > 0, "F", IF(SUM(COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 1**")+(COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 2**")) > 0, "P", IF(SUM(COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 1**")+COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 2**")+COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,"**PP - 3**")) = 0, "")))




    Thanks in advance




    Chris

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,661
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Help, i'm stumped

    Welcome to the Board!

    How about:

    =MID(" PPFFF",SUMPRODUCT(--(COUNTIFS(BPA!AK:AK,BN$4,BPA!AU:AU,$G8,BPA!$BF:$BF,{"**PP - 3**","**PP - 1**","**PP - 2**"})>0),{3,1,1})+1,1)
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •