Using COUNTIFS with CONTAINS

Nicole Hanik

When I try to incorporate a CONTAINS into a COUNTSIFS i keep getting errors

Works fine: =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, $Date$1)

Incorporate CONTAINS : These are 2 i tried

=COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, CONTAINS($Date$1, {JSA - Daily Job Start Safety Form Range 2}))

=COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, CONTAINS($Date$1,{JSA - Daily Job Start Safety Form Range 2}))

Try to achieve - FIRST: if Date = date on reference sheet AND Name Contains name on reference sheet, Then 1 else 0

David Joyeuse

Hi @Nicole Paulsen

You could try this:

=COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, CONTAINS($Date$1,@cell))

Depending on the type column that is in the {JSA - Daily Job Start Safety Form Range 2} you may run into errors as Date is likely a Date type column and your range most likely a string/text. And contains works with strings of characters.

If that happen, could you provide a screenshot or two with dummy data to sort this out?

David Joyeuse

Hi @Nicole Paulsen

You could try this:

=COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, CONTAINS($Date$1,@cell))

Depending on the type column that is in the {JSA - Daily Job Start Safety Form Range 2} you may run into errors as Date is likely a Date type column and your range most likely a string/text. And contains works with strings of characters.

If that happen, could you provide a screenshot or two with dummy data to sort this out?

Nicole Hanik

That worked! Thank you!!