Count If Formula

Katie Aldrich

Hi I am trying to create a formula that counts how many times "short" appears in a column when the column next to it that is "new".

Here is what I tried:

=IFERROR(COUNT(COLLECT(Term:Term, CONTAINS("Short", @cell) AND([Project Type]:[Project Type],(CONTAINS("New", @cell),)))))

=COUNTIF(Term:Term, CONTAINS("Short", @cell) AND([Project Type]:[Project Type],(CONTAINS("New", @cell),)))

NEITHER ARE WORKING.

Katie Aldrich

I figured it out :)

=COUNTIFS(Term:Term, CONTAINS("SHORT", @cell), [Project Type]:[Project Type], (CONTAINS("NEW", @cell)))