• MVP Logo
  • Recent Forum Posts

    ohhaykfrankk

    2010 index match

    My table is as such:
    Column B: Names
    Column E: Remainder
    Column K: Criteria is True or False.

    I need a formula that searches...

    ohhaykfrankk Today, 12:58 AM Go to last post
    Hercules1946

    Countif visible cells only

    Hello
    I don't think that COUNTIF itself will work, but it can be done using SUMPRODUCT, if that helps.
    See my attachment....

    Hercules1946 Yesterday, 11:48 PM Go to last post
    coachclint

    If statements

    thank you - the two formulas you provided are outside of my scope unless they are explained teacher to student
    as a caveat to this - how do you...

    coachclint Yesterday, 11:00 PM Go to last post
    NBVC

    If statements

    I was also going to suggest:

    =IF(G14="ns",-10,IF(ISBLANK(G14),0,LOOKUP(G15-$B14,{-9.99999E+307,4,6,8},{5,2,1,-5})))

    ...

    NBVC Yesterday, 09:33 PM Go to last post
    p45cal

    If statements

    What are all those AND(...)s doing in there?; they seem at first sight to be superfluous.
    You could also try the likes of:
    =IF(G14="ns",-10,IF(ISBLANK(G14),0,INDEX({5;2;1;-5},MATCH(G14-$B14-0.00001,{-9999;3;5;7}))))...

    p45cal Yesterday, 09:19 PM Go to last post