• MVP Logo
  • Recent Forum Posts


    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

    Countif visible cells only

    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

    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

    If statements

    I was also going to suggest:



    NBVC Yesterday, 09:33 PM Go to last post

    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:

    p45cal Yesterday, 09:19 PM Go to last post