Posts by Krayna


    I am working on a countifs formula to find cells which meet specific criteria. However I find the outcome incorrect because some cells have leading/trailing spaces. I cannot work out how to include a trim into this formula.

    My formula so far is:

    =(SUM(COUNTIFS((P21:FK21), {"Z","","B","#"})))

    Can anyone help with this?