SUMIF Partial Text

Nick Allgauer

I'm trying to sum the contract amount if the contract status contains Awarded. Contract Status is a multi-select column so may contain more than one status.

=SUMIF({Contract Status}, CONTAINS(@cell, "Awarded", {Contract Amount}))

This is coming back as $0 when it should be over $57k.

Thoughts?

Nick Allgauer

Never mind, I got it!

=SUMIF({Contract Status}, CONTAINS("Awarded", @cell), {Contract Amount})

Nick Allgauer

Never mind, I got it!

=SUMIF({Contract Status}, CONTAINS("Awarded", @cell), {Contract Amount})

Genevieve P.

Great! Glad you found an answer, and thanks for sharing 🙂

EducatorBoomer

Does this not work for contact list cells? I am trying to make it work in a column where there are multiple contacts allowed within a cell.

Genevieve P.

Hi @EducatorBoomer

I would suggest using the HAS function in this instance:

=SUMIF({Contact Column}, HAS(@cell, "Contact Name"), {Column to SUM})

EducatorBoomer

Yes! This worked - thank you so much!