Posts by Kieran

    assuming your list is in a1:a4, (change the range as appropriate) use the array formula
    =SUM(NOT(ISERROR(FIND("-1",A1:A4,1)))*1)


    Remember array formulas are entered with CTrl-Shift-Enter.
    If you do it correctly Excel will place { } around the formula - you cannot enter the 'curly braces'


    Kieran