SUMIFS with is blank and does not contain

Lisa B 2022

Hi, Could anyone help?

I need a sumifs with two criteria in two different columns, Column A Is Blank and Column B does not contain.

Any help?

Paul Newcome

There is an ISBALNK function you can use for Column A criteria

ISBLANK(@cell)

and you can combine NOT and CONTAINS for the Column B criteria

NOT(CONTAINS("specific text", @cell))

Lisa B 2022

@Paul Newcome Many thanks, I wasn't sure how to format that formula. Appreciate you taking the time to answer.

I got another answer as follows for anyone who has the same issue, works perfectly.

=SUMIFS([SumRange]:[SumRange], [Criteria1Range]:[Criteria1Range], NOT(CONTAINS("Criteria", @cell)), [Criteria2Range]:[Criteria2Range], ISBLANK(@cell))

Paul Newcome

@Lisa B 2022 That's exactly what I was talking about. One criteria is ISBLANK(@cell) and the other criteria is NOT(CONTAINS("specific text", @cell))