How to Sum if field contains the same text


Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum field.

Thank you

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.

    =SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])