SUMIFS & CONTAINS Formula returning #UNPARSEABLE

Chief Josh

Advice is greatly appreciated.

=SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", CONTAINS({Alpine Master Range 1} "Chasse", @cell))

Nic Larsen

Try:

=SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", {Alpine Master Range 1}, CONTAINS("Chasse", @cell))

DKazatsky2

Hi @Chief Josh,

You didn't provide a lot of information, so not sure exactly what results you are looking for, but see if this is close to what you are trying to do.

=SUMIFS({Alpine Master Range3}, {Alpine Master Range 2}, "Not Awarded", {Alpine Master Range 1}, CONTAINS("Chasse",@cell))

It looks like you just have a syntax error for the CONTAINS portion.

Hope this helps,

Dave

Nic Larsen

Try:

=SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", {Alpine Master Range 1}, CONTAINS("Chasse", @cell))

DKazatsky2

Hi @Chief Josh,

You didn't provide a lot of information, so not sure exactly what results you are looking for, but see if this is close to what you are trying to do.

=SUMIFS({Alpine Master Range3}, {Alpine Master Range 2}, "Not Awarded", {Alpine Master Range 1}, CONTAINS("Chasse",@cell))

It looks like you just have a syntax error for the CONTAINS portion.

Hope this helps,

Dave

Chief Josh

https://community.smartsheet.com/discussion/comment/480169#Comment_480169

Apologies for the lack of info, but you were indeed able to help resolve. Thank you.